Is there a simple way to combine all sheets located in a certain folder? I would like it to copy the data down, and only copy from row 26 down for all sheets. The sheets are all identical. Folder will contain 2-10 sheets. I would like the macro to be in my Template.xlsm sheet. I will open the sheet, run the macro, and the data is copied from the folder to the template. Thanks for any help.
Bookmarks