I am a "medium" Beginner when it comes to VBA and have a project I am working on, however I keep getting 1004 errors so hoping for another way to do this.

Each of my 7 sales people have a workbook, in which they save each sale they do. One worksheet in each workbook has a colum with total sales points for the week.

What I am trying to do is have my Master workbook pull the weekly points totals for each person so throughout the week I can see how my salespeople are tracking.

Now I have tried simply clicking in my master worksheet and putting = then clicking on the cell in the salespersons weekly summary cell, creating a link. I have also used index/match.

My problem is when I click data/edit links.udate values some of the salespeoples workbooks wont update without opening the file. This in turn throws a 1004 error with a macro I write to update the data from the salespoeples sheet to my master sheet.

Does anyone have a better solution for me? I am happy to start from scratch with my master sheet to make this work.