On front sheet i have B1 James, B2 Fred, B3 David etc
In C1, C2, C3 etc i want to read the overtime rate (H10)
from each of their sheets.

Put in C1:
=INDIRECT("'"&B1&"'!H10")
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Ali" wrote in message
...
Hi Max, i have similar hassle. each of my worksheets has a persons name.
Such as David, james, Fred.
On one front sheet, I am trying to combine all the info. Example:
Overtime
(will read off same cell but on 20 differnt sheets). Like Freddie wrote,
i
don't want to sit and change the names for each cell.
On front sheet i have B1 James, B2 Fred, B3 David etc
In C1, C2, C3 etc i want to read the overtime rate (H10) from each of
their
sheets.
Going wrong somewhere with the formula you suggested for freddie. can you
help. Thanks Ali