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