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!