merging sheet data

[Dave in Ampthill]

I have 3 sheets in a spreadsheet and wish the data in cell B27 on sheet 3 to
equal the data in cell C6 on sheet 1, i.e. if C6 = 3200 then B27 will be the
same. How do I write this as a formula or instruction?

Many thanks for your help,

Dave

 

[Dave in Ampthill]

Have already solved the problem, many thanks Max,

Dave