hi there, i need some help using offset.

on sheet 1, i have a table of data. on sheet 2, i manually pick a cell
and reference it to some cell in sheet 1. say for example, in sheet 2,
A1='Sheet1'!F1. what i want is that when i choose A1, A2 will have some
formula making it equal to 'Sheet1'!F6 and A3 will be equal to
'Sheet1'!F14. it seems like i should be using offset for this but i
don't know how to offset from another worksheet.

any help will be appreciated. thank you.