How come when you use Fill Data the formulas do not change across the other
worksheets when using Absolute References? All the formulas are the same on
each and every worksheet. I need them to change accordingly.

As an example, I am using $A1 in the formulas, which means I want it to be
$A2 on the next worksheet and so on until it reaches $A60. Can this be done?