I'm building a spreadsheet for work, its for quoting a price for
foundations on each house on a building site. i have a front page
which has column A detailing all the items required - simplified it
would be concrete, stone, bricks etc. Column B is the price/rate for
that item

then each plot has its own worksheet with the same format except with a
quantity to multiply by the rate to get theprice, the prices are then
summed and read back to the front page which has a summary for every
single plot. the problem i have is that there are 110 worksheets in
the book and we're trying to get to a basic template to use for
different building sites. the aim is to enter the specific
requirements i.e. the bricks concrete etc (which will change from site
to site) on the front page and have them update on each worksheet.

using a straight =sheet1 a1 type formula has the desired effect except
the formating isn't read. we need the titles to be in bold etc and
they may not always be in the same cell depending how many items are
falling under the heading for that particular site -which rules out
applying the format to each worksheet.

I've used the camera tool to put an image of the headings on each sheet
which updates as they update which works fine aside from the fact the
sheet is extremely slow to run.

having built a few websites i wondered if it was possible to create
something like an i frame where the headings are entered in one sheet
which is then embedded at the side of each individual worksheet and
remains fixed in place like a frozen pane - basically so that instead
of 110 images i'd have a link to another spreadhseet visible.