How to link a cell from other spreadsheet?

[Guest]

Does anyone know how to code following condition for linking?

There are 2 spreadsheets TTT and PPP:
I would like to link a cell A1 under report sheet for TTT spreadsheet from
a cell A1 under 6183 sheet for PPP spreadsheet, but the code of 6183 is
given in a cell B1 under report sheet for TTT spreadsheet.

Under report sheet for TTT spreadsheet,
I would like to use indirect function to join 6183 from B1 under report
sheet for TTT spreadsheet in order to form the link for A1.
Does anyone know how to code it?
Thank you in advance
Eric

 

[Guest]

This is a formula that links to cell A1 located on a sheet withing the same
workbook.

=Sheet2!A1

This formula links to an external workbook named DataSource , to sheet 1 in
that file and Cell A2 on sheet 1

=[DataSource]Sheet1!$A$2

 

[Guest]

Thank Kevin Backmann for your reply

='[DataSource.xls]6227.HK'!$C$2, which work in cell A1, but
I would like to retrieve the value 6227 from cell B1 for this statement
instead of manually input the value 6227 into the string.
Do you have any suggestion?
Thank you for any suggestion
Eric