Create nth copy of page 2, then reference first page with incremented row

Sorry - topic is slightly inaccurate - I meant nth copy of page 3....

Building a spreadsheet to help with employee benefit rate calculations. Data for employees is listed in the first sheet, rate information is on the second page and each subsequent page is for each employee. The pages 3 to nth contain the formulas the referencing page 2 and page 1 information.

I've got page 1 done and page 2 and 3 (first employee) done. I'd now like to enter employee data on the first page and have it autopopulate the nth pages using the formulas from page 3.

Summary.

Page 1 - employee list with data
Page 2 - data to calculate benefit info
Page 3 to nth - employee information formulas.

How do I get excel to generate an nth page if I add an employee
to page 1 (new row) using all formulas from page 3 (I can make it a template).

How do I get excel to change the new nth page reference to page 1 and row so the new page has to access the new employee line (new row).

thanks in advance....

PS. Auto naming the new page tab would be very nice with the employees name from page one when its entered....

Hello leesjunkmail001,

Welcome to the Forum!

To answer your questions you should post your workbook for review. Your description is like talking to a real estate agent on the phone to sell your home. The agent wants you describe your home. You say it is medium sized, with bone white exterior paint, a red front door,a front lawn with walk way, and 2 car garage. A lot of important information is missing about the home.