I am working on a rather large inventory workbook. I have a main page which
compilies data from 130 sites. Each one of these sites has it's own sheet
titled with a number ex:1, 2, 3, 4, 5. On the main sheet i would like to
fill data across a columns while keeping the cells "$frozen$" but changing
the tab title which it is pulling from without retyping it in every cell
since it is a rather large worksheet.

EX:
a b c d
Site 1 Site2 site 3 site4

4 '1'$d$2 '2'$d$2
5 '1'$d$3 '2'$d$3
6 '1'$d$4 '3'$d$4

So I would like to fill horizontally and keep the cells absolute but have
the name of the sheet change. My sheets are in numerical order