Hi,
I'm looking to pull the contents of multiple workbooks into one, and found this old thread, the first reply works perfectly:
https://www.mrexcel.com/forum/excel-questions/818972-macro-pull-all-data-every-file-folder-copy-data-into-open-workbook.html
However, that macro populates the...