Linking Tables

[schmill]

Hello,

Is there a way to link a table to another table and have the linked table update as the main one gets updated? What i have is a sheet with a table of a years worth of data, that is updated every day. I will take this data and sort it, say by name and then print it it out as a report. What i would like to do is to have multiple sheets with each sales persons name, on each sheet have a table that would dynamically update as i update the main table.

Any advice or help is appreciated.

Thanks, Schmill