Combine data from two sheets

Hello Team,

I would like to know if it is possible to combine data from two sheets with the same columns, but only use data from specific columns from the two sheets to the new one.

Please let me know how this can be achieved.

Many Thanks.

Answers