Table of Contents with Macros?

[jassyphee]

I know there are a lot of examples on the Internet regarding this topic, but none of them seem to do what I want it to. All I want is a list of page numbers of all the worksheets in the workbook excluding the first two worksheets from the page count, and return that value on each cell corresponding to it's title or cell name. Because I have already manually updated the title of each page in column A, I do not need a code for that because that remains static, instead, I want in column b the list of page numbers. Thank you!

 

[mikerickson]

If every sheet has something in A1 you could put this formula in a cell and drag down. (After substituting the appropriate sheet names for the first and last worksheet in the COUNTA)

=IF(ROW(A1)+2<=COUNTA(Sheet1:Sheet3!$A$1), ROW(A1)+2, "")