multiple lookups and pivot table

[bobbuilder123]

Hello you lovely people,

I need your help.

Sheet 2, I need to lookup up cell A4,E1 and E3 from the pivot table on "pivot" tab, to display the result in cell E4.
I then need this formula to be able to be replicated by dragging it to the right and down.

I hope that makes sense?
How do I upload a file?

Thanks
BoB​