Hi,
This is my first post. Hope you can help.

I have a form that has been copied 100 times in 100 sheets. I also have a data sheet that i require to only show parts of each form.
Example:
Name
Date
Cost
Ref Number

How can i do this quickly without going int each page for the info. I tried dragging the original formuler but it changes the cell and not the sheet. I need the cell to stay the same but the sheet to change.

Hope that makes sense