Excel worksheet formula question

I am using PC Windows 11 and Microsoft 365. I am creating a yearly workbook with 12 worksheets (tabs). I want to create formulas that involve data from the prior worksheet. For example, on worksheet 2, I want a formula that takes a cell value from worksheet 2, subtracts a value from worksheet 1, and calculates the new value on worksheet 2. I have done this, but only by clicking on cells I want used in the calculation (in a cell on W2, I type "=", click on a W2 cell, type "-", click on a W1 cell, and press enter). This works, but now I want to copy W2, rename it W3, and not have to go into each cell and recreate the formula, because the formulas on W3 will refer to the W2 and W1 cells used on W2. I need the formula to include "prior page cell D7" instead of "W2 cell D7", so that each pages' formulas will refer to the prior page (whatever its name is), and not the "name" of the prior page.