Referencing a Different Sheet for all the formulas in a copied graph

Hi,

I have multiple sheets with the same exact layout but different data. Let's just call the first two "Sheet Hockey" and "Sheet Football".

I then made a line graph for Sheet Hockey and moved it to its own sheet called "Hockey Graph". Next, I created a copy of "Hockey Graph" and labeled it "Football Graph". Instead of having to go through and change every formula from "='Hockey Graph'!$D$40:$D$70" to "='Football Graph'!$D$40:$D$70" individually I have been trying to write a VBA code to do do this for me and have searched for this question here but couldn't quite find what I was looking for.

Could someone help me with this code to replace all of the sheet references so I can make multiple graphs much quicker?

Thanks!

You can use Find and Replace for this.

This doesn't seem to work for Microsoft 2010. Maybe I'm doing something wrong but I used to use that but can't get it to work now.

Thanks