Not sure if my subject helpeds explain much.

I have a "register" worksheet, that tabulates all the information found on
the other worksheets in the database. The register worksheet is called
"register" and the other worksheets are numbered "1", "2", "3" and so on.

At the first row of the register worksheet, i have a lot of cells that
reference off the "1" worksheet. Simple links so i can see all the
information i want on one screen.
On the second row of the register, i want the same cell locations, but on
the second ("2") worksheet, and this continues through. The first column
contains the worksheet number "1", "2" etc.

I've hunted around with different fill techniques, and different reference
techniques but haven't been able to find anything. Hopefully someone out
there has a better idea than i do. Open to ALL ideas as its is just a new
spreadsheet.