INDIRECT sheet references within LOOKUP function

Let's say I have Sheet 'A', in which I want to gather information within one cell from another Sheet 'B' to Sheet 'Z'. I want the reference Sheet name to change dynamic, according to a cell value (text) I enter in Sheet A. The row from where the data needs to be picked up can differ, so I added a Value in a cell of the reference Sheet, that will not change. This is in the same row as the value I want to pickup.
I've used LOOKUP on functions where my reference sheet does not change and this works fine for me. Working with variable reference sheet name, is just killing me right now. I need the sheet name 'Jul2016'! to be dynamic according to the value in B5 of my Sheet A.

=LOOKUP("MonthKPIs";'Jul2016'!A:A;'Jul2016'!J:J)

This is, what my function looks like at the moment. There seems to be something going wrong...

=LOOKUP("MonthKPIs";INDIRECT("'"&B5&"'!&A:A");INDIRECT("'"&B5&"'!&J:J)

MonthKPIs is the static cell value on all of my delivery sheets. So I want Excel to find this value on the sheet.

The cell B5 on my destination sheet should define the name of the delivery sheet, where I know the reference value "MonthKPIs" is in column A. So I want Excel to find MonthKPIs on the Sheet that is defined be cell B5.

The Value to return is in the same delivery sheet, but this time in column J. So I want Excel to return the value in column J of row "MonthsKPIs" on the sheet with the name from cell B5.

Does this make sense to anyone? I'm not even 100% sure INDIRECT is the right thing to use...

I see a missing " and ) at the end, and extra & between ! and A:A/J:J
=LOOKUP("MonthKPIs";INDIRECT("'"&B5&"'!&A:A");INDIRECT("'"&B5&"'!&J:J)
Should be
=LOOKUP("MonthKPIs";INDIRECT("'"&B5&"'!A:A");INDIRECT("'"&B5&"'!J:J"))

You still left out the closing " at the end
=LOOKUP("MonthKPIs";INDIRECT("'"&B5&"'!A:A");INDIRECT("'"&B5&"'!J:J"))

They are there because you are using a range that is text, and all text in a formula needs to be wrapped in ""

Jonmo, didnt mean to muscle in lol, wasnt sure you had seen the reply
Happy to help, Jonmo did all the heavy lifting