I am trying to update data on mutiply sheet into one spreadsheet
This is a fornightly payroll workbook where each sheet is the date of the
fornight payment. After I set up the vlookup formulae to pick up the first
pay period in say colum c. Can I edit the formulae to pick up data in the
next sheet, without actually typing in the sheet name or using find and
replace.

Staff 4-Jan-08 18-Jan-08 1-Feb-08 15-Feb-08 29-Feb-08

Rusty Brown 0 14,300 10,300 14,300
Uton COUBOURNE 0 28,375
Ernol FOX 0 22,454
Anseka Gibson 0 14,300