Linking Workbooks

C

cathy

I'm not sure if this is an excel function or an access function. (I don't
know Access - however I'm fairly well versed at Excel).

My company has a separate Excel spreadsheet with data for each client. We'd
like to continually update the data in the client specific spreadsheet and
have a separate worksheet that regularly pulls the data from all clients/all
worksheets that we may then reference, sort etc.

How would we go about establishing this? Thanks.
 
Top