Finding data from other sheets

[helpme71]

Hi.

I have a team of 30 people. All of which have individual worksheets, these have 5 tabs for each day.
I have a master tracker form which I place all the customer numbers on and details. Currently I have to manually input who is working on that customers order as well as the day they picked it up.

Is there a way of pulling this information onto the master sheet automatically?

I have enclosed blank copies of both and would appreciate any help with this.

thanks

[davesexcel]

Your worksheets don't match, you should have filled in a couple of lines on each sheet.to show what you needed

[helpme71]

Apologies, Have not input one order number on the master sheet and name and date picked up on the other staff's worksheet. I need to pull through the staff name and date picked up onto the master sheet, I have up to 30 members of staff who could have been working on this order for example.

[6StringJazzer]

This is a duplicate thread. Please close this thread or the duplicate one at

http://www.excelforum.com/excel-gene...el-sheets.html

In the other thread I posted saying pretty much the same thing that davesexcel says here.