Hi Experts,

I have a code which I have gathered by doing some research in Google and this working fine for me . Suddenly the requirements have been changed and need to modify the code accordingly.
Please Login or Register  to view this content.
I use this to select a workbook with only worksheet and then copy the column 3 data into my master macro sheet.
Now we have 1 master macro sheet and 1 Workbook with multiple sheets.

I want to run the macro and it should go to the Workbook and select the name of the worksheet (as per the macro name) and copy paste the data in the master workbook.

Could you please review the code and suggest ?