I have a workbook with numerous tabs in it and I need to create a macro that
will pull information from the previous tab. I want to copy this macro onto
multiple sheets without having to change it. The formula needs to reference
the tab directly preceeding it. I recorded a macro and entered = and then
hit control / page up. However, when I copy this onto other tabs, it still
references the original tab that I linked too. Control / page up works in a
macro for other functions (copy/paste, etc), but not to create a formula.
Any ideas on how to make this work?

I hope this post isn't too confusing, sometimes it's hard to explain what
I'm doing.

Thanks!!!