Hi, I’m new here.

Basically my problem is linking.

I link cells from 1 spreadsheet (named CMF) to another sheet (named BAR) for each month.

But I have to change the description in each and every single cell on the BAR sheet each time the month ends, for example…

On the September BAR tab, I must change

=‘August CMF’!c33

TO this…

=’September CMF’!c33

I must create new September sheets/tabs for both the CMF and BAR, as I cannot overwrite the August tabs with September data. So I’ll have September Bar, September CMF, August Bar, August CMF, and so forth. There are tons of cells to change, and manually changing and typing August to September is very time consuming and it tends to hurt your wrist when there are around 30 days and dozens of accounts.

Is there an easy way to do this? If I’m not making sense, please ask for more input from me. Also please remember I can’t overwrite any old data, as I am creating entirely new sheets with the same format…I just don’t want to manually change each cell to have the proper link. I’ve been doing it the past 2 months or so and I’ve had it.

Any help is appreciated and sorry for the long post!