One way, use this in the startcell:
=OFFSET('Tab C'!AB$91,,COLUMNS($A:A)*2-2)
Above returns the same as: ='Tab C'!AB$91
(note that I assumed the source sheetname is: Tab C)
Just copy the startcell across to extract it exactly as desired
Success? wave it, hit YES below
--
Max
Singapore
---
"RD" wrote:
I am trying to link every 3rd column in Tab C into Tab A. Is there an easy
way to do this via a formula - I have tried Indirect and column however not
having any luck.

Basically in Tab A on Cell A2:
<Column A <Column B
=Tab C!AB$91 =Tab C!AE$91 etc.
In above case, is there a formula that can help me automate the calculation
in Column C?

Thanks so much!