Referencing Cells in other Sheets using the Address function

[Cpflum]

I'm building a table that references a dynamic range on a pivot table. So far I've gotten the function to return the address on the pivot table but it wont return the value. I'm doing this so that I can both refresh the two source data sets and summarize (pivot table) and also graph these two summarized data sets since you can't graph two different pivot tables together.

This is my code so far:
Iferror - To return zero if the source data doesn't exist yet
Address - To concatenate the match functions
Match - to find the row and column numbers on sheet "B" that match the x,y call on the original sheet "A"

=IFERROR((ADDRESS((MATCH($A2,'Install Data Pivot'!$A:$A,0)),MATCH(B$1,'Install Data Pivot'!$4:$4,0),1,1)),0)

Returns $B$5 since this is the cell where the information lies.

I've tried just adding the sheet name like this...

=IFERROR('Install Data Pivot'!(ADDRESS((MATCH($A2,'Install Data Pivot'!$A:$A,0)),MATCH(B$1,'Install Data Pivot'!$4:$4,0),1,1)),0)

...but that doesn't work. I've also tried using different variations of Indirect and Index but I still can't get it to reference the other sheet.

Help Please!

 

[Robert Mika]

If you need to returh the value from the $B$5:
=IFERROR(INDIRECT("'Install Data Pivot'!"&ADDRESS((MATCH($A2,'Install Data Pivot'!$A:$A,0)),MATCH(B$1,'Install Data Pivot'!$4:$4,0),1,1)),0)