Use just the one sheet, and filter on your column of job id using Data / Autofilter then selecting
the job from the dropdown value.

HTH,
Bernie
MS Excel MVP


"pdfervent" wrote in message
...
ok heres my prob...im using excel to keep track of payroll for 3 different
jobs and i was wondering how i can enter names, dates, times and rates on one
worksheet and have it generate a sign in sheet (that is standardized and
recreated in excel) with all the entered data for each seperate job on 3
seprate worksheets.

hope someone understands this...its driving me nutty