Hi

Sheet Leadboard contains

B6 Sheet1
B7 Sheet2
B8 Sheet3
...
...
B150 Sheet145

Sheet1 contains data in cells B2, B3, B4, B5, etc that I wish to link.

I have tried various formula and got no where

in C6 - I would like =&B6&B2 to pull in the answer from Sheet1B2.

This is going to be shared accross around 150 people so the MoreFunc in my previous version will not work.

I am sure this is very simple or I hope it is...

Thanks in advance,

R