Hi

I need a macro to open the browse window and enable me to choose the file i want to open. Then copy the specific worksheet(entire) from recently opened excel spreadsheet to the macro file. I want this to be done for 3 files so I would need a loop function as well.

Please help me as I am unable to set up the correct VBA code in this respect.

Thanks in advance.