Hi, my first post so bare with me!

I have a master sheet of a budget for my self build project. I have allocated cost codes to my master cells i.e. First Fix is FF.

I know the formula =name of sheet!name of cell

however, I have several cells across numerous sheets that pertain to certain cost codes.

The other sheets in my workbook are named Furnishings, Building Materials, Exterior, tools, Contractors etc. Say I have named lighting in one of my sheets, I have put my Budget, Cost and VAT then Cost Code. How do I link each item that is labelled FF, across all sheets to the master sheet? E.g.

Sheet 1 = Building Materials:

Item Budget Cost VAT Cost Code

Lights £100 £85 £15 FF

Flooring £2000 £2300 £320 PC

Glazing £3000 £4200 £714 WWT


Sheet 2 = Exterior

ITEM BUDGET COST VAT COST CODE

Fencing SF

Driveway SF

Gazebo C



Sheet 3 = Master Sheet:

STAGE Budget Cost VAT Cost Code

Preliminary Costs PC
Foundations F
Wall Plate Level WPL
Wind and Water Tight WWT
First Fix FF
Plastering P
Second Fix SF
Completion C