automatically transfer data between worsksheets when sheet is opened

[mufan]

Hi,
I faintly remember this being done by someone years ago but can't remember how they pulled it off nor can I find it on the internet. I have Microsoft Office 2010. Basically, I have employees putting information into an excel sheet. I want data from specific cells of that worksheet to be transferred to specific cells on my worksheet. It would be cool if I could just open my worksheet on the computer they use and it goes and grabs the data itself but if I have to manually tell it to go get it then that is fine too. Any suggestions on how to do this? thanks!

[marreco]

Post an example of what you want

[mufan]

I want to ammend this post somewhat. I have attached an example of the two worksheets that I am talking about. There is a date on the "sheet that I want to pull data from" on each of the days (day1, 2, etc on tabs). Is there someway that my worksheet ("sheet I want to add data to") would be able to search the date that is on each of the tabs and pull data from the cell i program it to pull from? I use v and h lookup on a number of spreadsheets but I can't make that work in this scenario.

So in summary, I want to open my worksheet on the computer that they input data into their worksheet. I then want the most efficient way for the data to be transferred from their worksheet to mine. I would prefer a method where it searched for the date and found the data on each of the tabs but I can live with using + or = and referencing the cell that I want.

thanks.