Accessing data in different worksheets by referencing from a master worksheet

[dow400]

hi there,

I am trying to build a master worksheet whereby I will be collecting specific data from a number of worksheets that are named in a specific fashion. I have attached a sheet to make this clearer. In worksheet MasterI would like cell c4 to access worksheet SPX and fill out C4 if L3 equals BUY. Similarly so for D4 if SPX!L4 equals BUY, E4 if SPX!L5 equals SELL and, F4 if SPX!L6 equals Sell. I attempted this by using indirect and many other combinations yet it doesnt work. I appreciate your input with this.

Regards,