Hi All,
I have c. 200 spreadsheets in a folder, I need to quickly copy sheet 1 of each of these and paste them into one workbook. I would also like to name each sheet in the new workbook as the last 9 characters of the original filename.
Can anyway help with an easy way to do this.
Thanks,
Marshybid