Code for compiling/copying a data from an entire sheet to an excel file saved in local/shared drive

[ram8gig]

Hi Everyone,

I have a number of excel files (same format) that i need to copy and compile to a master file saved in a local drive. Ex. Agent 1 (sheet 1), should be save in a master file sheet 1, Agent 2 (sheet 1), should be save in master file sheet 2.. and so on.. Can someone teach me what code should i be assigning to a "record" button (macro)?

Note: excel files were saved in the same local path:\ drive.

Appreciate your help!

Thank you very much!

 

[ram8gig]

i appreciated the time you spent viewing this thread, but i would be more happy to any response related to my query..

Thank you in advance.