Have I been asked the impossible?

[CharlieBeth]

We have a pretty large workbook that we use at a site where staff are paid "per unit".

We work on a page-per-day to record who has worked on what with who, and what they have earned. (Staff work in teams, earn money based on units worked, and split the money between that team. Teams are often different daily)

I need to be able to have a front summary page auto filled with what each staff member earns, even when we have different staff on daily, working in different teams.

Could some one help me with this? VLookup and HLookup don't seem to be working on the system we have.

I can send a copy of the workbook in question if needed

 

[CharlieBeth]

What other ways are there of searching out info and displaying it in a different place within the same book?