Help with INDIRECT() Function Using Autofill

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!

Thank you very much, this seems to be working without a problem.

I sincerely appreciate all the help received, it will save me hours of time.

Glad you have solution.

But as added value, you can pretty much cut the original formula in half

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

Now you only have to apply the solutions by Ford or Tony twice, instead of 4 times.