Hi everybody,
I have a master file named "Trial.xlsm" and multiple xlsm files in a shared folder. Master file contains sheets named "Report" , "Data" and "Sheet 1", "Sheet 2"... to "Sheet 30". (Totally 32 sheets).
In other xlsm files all are having sheet named "List" and a Chart.
I need a macro that copies the data from the sheets "List" and paste it to "sheet 1" to "sheet 30" of the file "Trial.xlsm".
I have a macro that moves the sheet again and again when running repeatedly. And i have named ranges in sheets 1 to 30. So that i need to copy the data.

Anyone help...