get the offset cell value from a different worksheet

[plans]

Hello,
I have a formula in cell A1 like: ='UnCW'!B19 when UnCW is the name of an non active worksheet.

I want a formula in cell A2 to get the value of the offset (0,6) of 'UnCW'!B19

What would be the formula in A2?

Tried "INDIRECT" but probably, I am writing it incorrectly.


Thanks

[AliGW]

This I presume:

=OFFSET('UnCW'!B19,0,6)

[Fluff13]

Why not just use
='UnCW'!H19

[plans]

Thanks for the responses but they won't work.
I need to have the formula look into the address noted in A1.
Colum A has multiple rows and I want to be able to drag down the formula in A2 and get the values.
Any thoughts?
Thanks

[Pepe Le Mokko]

Perhaps post a sample sheet ( see yellow banner)...?

[Fluff13]

Maybe
=OFFSET(INDIRECT("UnCW!"&A1),0,6)