Formula to Cell J4 based on Workook name in Col A & sheet name in Col B

[howard]

I have workbook name in Col A & sheet names in Col B. I will would a formula to extract cell J4 from the workbook in Col A & sheet name in Col B

See link below for sample data

Dropbox - File Deleted - Simplify your life

www.dropbox.com

Your assistance in this regard is most appreciated

 

[Toadstool]

Hi Howard,

Put into C2

=INDIRECT("'["&A2&"]"&B2&"'!$J$4")

and copy down, but the target workbooks must be open.