Copy Cells using reference in cell to another workbook

[lulu_online]

I have two workbooks. One named Trending 2012, one named 2012 YIELD CALCS. I want to copy the data from the Yield 2012 workbook to the Trending 2012 workbook.
The Trending 2012 workbook has multiple sheets which are named the same as one row of the cells in the Trending 2012 workbook. I want a formula similar to the following, but can't get it to work out for me. Tried the INDIRECT function, but can't seem to get it work.

For Cell L19 ='[2012 YIELD CALCS.xlsx]A1216'!$B$4 but have the A1216 filled in by a link to the text in cell A19

A1216 is the worksheet name in the Yield Calcs Workbook and is also text in a cell (A19) in the same row (in the Trending 2012 worksheet) that I want the information from B4 (of the A1216 worksheet) to be copied.

Please help!

[mahju]

Hi

To see the use of indirect function see

http://www.excelforum.com/excel-misc...her-files.html

Regads

[lulu_online]

Because A1216 is the name of the worksheet in the workbook I need the information copied from, the INDIRECT function does not appear to work for this.

I just need to know how to get excel to enter the text from cell A19 into the formula I have above for cell L19 instead of the formula having to have the letters/numbers A1216 in it.
L19 ='[2012 YIELD CALCS.xlsx]A1216'!$B$4