Hello,

This is my first ever forum post so be gentle with me! I can use Excel but am by no means an expert.
What I am doing is creating a master worksheet which lists all the different building projects my company has been involved with. The master worksheet contains lots of formulas including long nested IF functions to retrieve the relevant info from the first worksheet '001'. Now I want to copy the formulas (which I normally do using Ctrl D) so they reference the other worksheets, i.e. 002, 003, 004 etc etc..

Can anyone point me in the right direction?

Many thanks indeed,

Justin