I am just going to explain what I am trying to do to see if any of you guys can help me.
Basically a simplified version of what I am trying to do is this:
I want to refer to cell A1 in sheet1 from A1 in sheet2. I have a macro set up to insert a row above row 1 every day in sheet1; however...