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.