Try VLookup or HLookup. If you have a "main" table with a common field to
the other tables these should work well for you.

"BeginnerExceluser" wrote:

How do I set up an Excel worksheet that compiles data from other Excel
worksheets. If the directions are too lengthy what is the proper Search Term
to use?