I am currently using the INDIRECT() function in multiple formulas to get around the design of a specific workbook. The workbook grabs data from a website and then sorts the data into a different spreadsheets within the workbook. Whenever new data is needed or the specific data to grab is changed, the workbook macro deletes the current spreadsheets holding the data and creates new spreadsheets containing the new data. The name of the spreadsheet stays the same, but the act of deleting the spreadsheet ruins the formulas unless INDIRECT() is used. Due to this, I have been using the INDIRECT() function so that the formulas in another spreadsheet that reference back to these deleted spreadsheets still work.
Here is one of my formulas

=IF((INDIRECT("'My Data'!B3")-INDIRECT("'My Data'!B2"))>0,INDIRECT("'My Data'!B3")-INDIRECT("'My Data'!B2"),0)

However, due to the INDIRECT() function, I can't just autofill or drag down the formula, as it doesn't change any of the reference cells. I want it make the formula above go up in one cell each when I drag it down, so the formula above would be

=IF((INDIRECT("'My Data'!B4")-INDIRECT("'My Data'!B3"))>0,INDIRECT("'My Data'!B4")-INDIRECT("'My Data'!B3"),0)

I am need to use this formula to fill a lot of rows and columns, so I am looking for a fast way to be able to get excel to recognize the autofill formula I want.
Any help would be much appreciated, thank you!