Hi.

I want to do the simplest thing possible; count the number of sheets in a
workbook and show the result in a cell.

See, basically, I want every new copied sheet to have a reference in a cell
like this:
=(numberofsheets)-1

I know about the footer and header but I have sheets that are for summary
and index reasons which would throw off the count of the sheets I intend to
copy.

Not sure if this makes any sense, I pretty much just want to count the
number of sheets with a formula.

Thank you,
Olle Svensson