Transfer Data from One Workbook to Another

Hello,

Does anybody know how to transfer data from one workbook that's open to another in a macro form. I included two sample data workbooks I have. Sample will have the macro inside it and will already be open for the other portion of the macro that will be running. I already have code that will open up the Sample2 file. I'm trying to take specific data from Sample and paste it into a summary sheet in Sample2. In Sample i will be cycling through roughly 30 sheets to find this data but I only included one because I just need to know the basics on how to make this work and then I can figure out how to modify it. Any help is greatly appreciated. Thanks again.

Sample2.xlsx Sample.xlsx

Does anybody have any ideas?

Thanks for the reply. That's somewhat the same as mine. Instead of copying an entire sheet from my second file I'll actually will be pasting information from Sample 1 into Sample 2 and continue going back and fourth between the two workbooks. I have about 30 separate people that represent a sheet in sample 1 that I will need to gather information for and each person I will need to get about 10 different fields of information. Does anybody have any ideas?