Formula to copy & paste specific cell data from one sheet to another

[saidhruv]

Dear All,

Request your help in creating a formula which can:

a. Copy data from specific column from a sheet that has all formulas.
b. paste copied data into another sheet from same workbook as paste as values.

Sample excel attached. Columns from sheet LAB to be pasted into sheet FINAL as values.
LAB -> O3:O102 to be pasted into FINAL -> D1:D100
LAB -> AD3:AD102 to be pasted into FINAL -> E1:E100
LAB -> AS3:AS102 to be pasted into FINAL -> F1:F100
LAB -> BH3:BH102 to be pasted into FINAL -> G1:G100

Note: i have several workbooks where the address of specific column which are to be copied may change, i.e. the example shows column O but in some other excel it could be G.
So, i guess formula would be better rather than a VBA. In case VBA is the solution, i should be able to change the column names within VBA itself.

 

[vletm]

Write
... to FINAL!D1 =LAB!O3
... to FINAL!E1 =LAB!AD3
... to FINAL!F1 =LAB!AS3
... to FINAL!G1 =LAB!BH3
after that copy that range as down as needed

 

[saidhruv]

Write
... to FINAL!D1 =LAB!O3
... to FINAL!E1 =LAB!AD3
... to FINAL!F1 =LAB!AS3
... to FINAL!G1 =LAB!BH3
after that copy that range as down as needed

dear vletm - i have tried this, however it copies along with formula. can there be a way to copy as values?
secondly, it is manual work. i have around 600 files that have these kind of sheets. it would help if i get a VBA or formula that copies data from LAB to FINAL as values.

 

[vletm]

1) You asked formula and that means manual work too!
2) There were no formula in those cells (quick check only)
3) So, i guess formula would be better rather than a VBA. .. YES/NO!
4) If You would like to get VBA and those columns would change
is there something which keep always same, like header-information.