Pivot Table Problem & External Data - Microsoft Excel

Hi I'm having a major issue with Pivot Tables, Name Manager & External files. This video explains the issue. Any help will be very helpful! ... https://www.youtube.com/watch?v=WvrGebJqvvc