Create sheets based on master list and sheet template

[apriljean]

I am trying to make timecards that update from a master list.

First worksheet - master list with rows of info (name, acct code, time in, etc)
Second worksheet - timecard template (cells call upon info in the master list)

I can make sequential worksheets based on a list (column A), but I cannot seem to get the formulas in the worksheet to call upon the sequential rows for info - essentially, each timecard has a new name (column A) but continues to call upon all the cells in Row 1. I can go in manually and change the cell number in the formula … but that takes a while for a large crew! There must be a better way.

Thank you for the help.

 

[My Aswer Is This]

What does this mean:

cells call upon info in the master list

Calls Upon ??
Do you mean you have a formula in the cell.
If so show me the formula.

​

 

[apriljean]

Yes.

For example:
=IF(TIMES!B7="","",TIMES!B7)

This is a formula from one cell in Worksheet 2, "Times" is the master sheet. The same cell in Worksheet 3 should call upon (sorry if that is the wrong lingo) B8, and so on.

I have been able to create a sequence of worksheets based on Column A (employee names) but each new worksheet continues to call upon row 7 - I would like each new worksheet in the sequence to move down the rows so I do not have to change each row number in the formulas manually (there are approximately 20 formulas per worksheet that call upon the master sheet for info.)