Excel VBA to get the Print Preview page number for every sheet

I have an excel sheet which will keep on adding new worksheets or deleting existing one. The current VBA code, creates a table of content, with the page number for each worksheet. However instead of the page number, I need the first page number of the print preview page for each worksheet. Attached is the excel sheet, and in the cover worksheet, I have shown the correct and incorrect page#. The excel works with a maximum of 50 worksheets, ad as the works sheets are more than 25, the next ones get added on the second part of the table in the cover worksheet. The VBA code that you build should be able to address both those columns (upto 50 excel worksheets). Also as new sheets are added, and the current macro is run, your macro, should automatically update the new page numbers [login to view URL] it in the next 8-10 hours. Ready to pay 1000 INR for this work. Please include "Can get page#" as the first line of your bid.. Bids without this line will not be entertained.