I have a formula in a cell, ='Apr 2019'!M13 This is for May 2019. When I create June 2019 sheet I need the Apr part of the formula to change to May 2019. Also same thing with this cell formula, =IFERROR((Q81/'Apr 2019'!Q81)-1,0), when I create June 2019 need Apr to become May and so on. I have several cells that reference the previous months cell data but when I create a new month I have to manually update these cells.
I guess I should have added the worksheet name. Each sheet is named Jan 2019, Feb 2019, Mar 2019, etc.
First 3 letters of the month space then current year 2019
But I appreciate the help, I think I know where you're going but the worksheet name with the space in it might need extra work.
I did up to Jun 2019 so the way I do it is copy all the cells in Jun 2019 and paste and into new sheet and manually change all the references to May that June used into the July 2019 worksheet with references to Jun 2019.
=IFERROR((C14/'May 2019'!C14)-1,0) This is the Jun 2019 worksheet, so July worksheet would need to change May 2019 to Jun 2019.
then another formula, =SUM('Jun 2019'!C14-'May 2019'!C14), in July worksheet I would change the months,
Yes, that was only an idea, which parameters to use that's up to you - months only or entire sheet name. And it looks like you need another parameter cell with the name of the current sheet. With this, if you copy your sheet on next month the only you need is to change the values of these two cells.