In order to learn about how to move data from one sheet to another in vba, you must check this out. I was going to use a range but I found it faster just using an array and pasting that data to a new workbook.
This video is showing how to move data from one sheet to another in vba but also try to cover the following subject:
-vba macro to copy data from another workbook in excel
-copy data from one sheet to another
-how to copy data to another workbook
_________________________
If you wish to learn more about vba macro to copy data from another workbook in excel I suggest you to look into our other videos : / @techtinktronics
++++++++++++++++++++++