Ok so I currently have 5 separate files with say about 10 tabs in each file (each file represents a different division of the company). On a monthly basis I need to consolidate all of these tabs in each of the 5 files into one master file. Is there a way for me to select a range of tabs (say Sheet1 - Sheet10 for example) and copy this and move it to the consolidated file, but move it to the end of all the tabs that may already be existing in the consolidated file? I know how to toggle between files using the ActiveWorkbook.Name code, but am a little stumped on how to copy tabs between the two files. Can the range of tabs in each file be copied all at the same time or would I need to loop through each tab and copy them one by one? TIA.
Bookmarks