How to update sheet references in excel formula?

I am having trouble updating a sheet reference in a database.

The format of my formula is like so:
=(SUMIF('Raw Data'!$B:$B,"P0900",'Raw Data'!D:D))

I want to write a macro to update the "Raw Data" worksheet so that a new one will be created according to the selected date (and it will be renamed correspondingly).
I tried to use the indirect function so that the formula becomes

=(SUMIF(indirect(raw_data_sheet_name&$B:$B),"P0900",indirect(raw_data_sheet_name&$D:$D))

where raw_data_sheet_name changes based on the date.

This method would work except that I have thousands of cells to update. I tried using the find and replace function in excel but it doesn't work since it would make the formula incomplete.

Is there a macro I can use to solve this?

Thanks!

I don't know if there is an easier way but this is how I solved this problem:
1. I converted the formulas to non formulas by using Excel's find and replace for the "=" sign and replacing it with an arbitrary string.
2. To convert the sheet names I simply used find and replace.
3. To put brackets and quotes around the ranges, I used a macro that used the instr() function to find the location of the ranges, and used an insert string function (can be easily found online) to insert the quotes and brackets at the corresponding indexes.

Hope this helps anyone viewing this post.