Hi dreamwarden,

Looking at your data, it appears to be very easy problem.. provided that the Formats don't change from the file you've posted. If I've understood it right, then you are just fetching the same data from all projects onto one table (in this case, that table is sheet 'Stage 28').

So, this becomes only a cell linking problem. I won't touch VBA for this. What I'd do is -
1. Make one project's entry manually, in the sheet Stage 28. Meaning, copy the required cell/s & paste special them in Stage 28 sheet with an option of 'paste links'
2. Then copy all those links for second project, hit Ctrl+H (find & replace) & ask it to find 'ct 1' & replace with 'ct 2'... try it, that's magic!
3. Repeat this step 2 for all projects, except every time I keep increasing the number in Ctrl+H operation.

A VBA code will be little complicated for this task, in my view.

Trust this helps you.