Create a Pivot Table from 3 Name Ranges

I have a spreadsheet with multiple worksheets. I have created 3 name ranges and tables from 3 different worksheets. The 3 ranges have a common column called Site. One of the ranges has unique values and the other 2 ranges have multiple values of Site. I have tried to create the relationships but it's not working properly. I will attach the spreadsheet. The 3 sheets in question are Sites, Weekly Archives and Weekly Income. I want to use Site as the filter and just for the moment a couple of fields from each of the other 2 ranges. Both should include the name field. Let me know if you need any further info. Many thanks in advance.

ok so what you're suggesting is forget the pivot table? You might have a point. I'll give it a go and see if I can get the report I need. Initially I was suggesting any 2 fields but one must be the name just a test. I've got to go back to the client and find exactly what fields she wants. Many thanks for replying to my question.

yep that's great thanks.