Hi,

I am trying to reference a specific cell address (say B5) from each sheet in my workbook, and produce a column that contains B5's value from each sheet. Hopefully this is enough info for someone to correctly analyse the issue i am having. Thanks.

Al