If the same exact columns are present in both sheets but different locations, you can read range Sheet 2 and rearrange to match the columns of Sheet 1: How to change the datatable column sequence
But if the columns are totally different, you can remove some of the columns of the Sheet2 DataTable first, rearrange and then paste onto the Range once the transformation is complete.
Thanks!!