Compile worksheets from multiple files into one workbook

I've looked all over the web, and I can't find a solution to my problem.

I know how to link individual cells to external files, but how do you reference an entire worksheets?

What I'm trying to create:
I am creating a sales tracker, where each rep has a file of their own. I've set up a userform to automate the entry of data on the rep files, so the data placement and format is consistent between all of the individual rep files.

I also have a master sheet that is used to generate the rep trackers themselves, so the file locations and names are all automatically set.

File locations:
Tracker\MasterTracker.xls
Tracker\Reps\Rep1.xls
Tracker\Reps\Rep2.xls
...etc.


What I can't figure out:
I have the tracker creation automation set up just fine, but what I need is for the master workbook to automatically add a worksheet/tab called Rep1, Rep2, etc, and reflect the information that's actually stored in the individual rep files.

Is this possible without manually linking each individual cell? If so, how?


Thank you so much!!