I’m needing a VBA macro for Excel. I have many files just like my example (attached). I would like for these individual files to be combined into one file. Each file/spreadsheet is to be appended to the bottom of the next. All files have the same header information. It does not matter what order they are appended. All files/spreadsheets will have a “sheet1” that’s populated with the needed data.
Please let me know if you need further information. Thank you.