Hi
I will start by saying i am not at all good with macros but have been asked to put a button on a excel sheet that will open every other workbook in the same folder and copy the sheets individually to separate workbooks and name the workbook the same as the sheet it came from.
Suffice as to...