Need help with macro to perform following task.
1. I have a file (Original file) with 6 sheets (Index, Report1, Report2, Report3, Report4 and Data)
2. Report1, 2, 3 and 4 sheets are linked through formulas to 'Data' sheet
3. Colum A in Index sheet contain list of sheets to be copied to a new...