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.