Ok so I have what is probably a very simple problem that is driving me nuts.

I have a Worksheet what is a Master Sheet, that needs to pulls data from 8 other workbooks.

They are all saved in the same folder on a network drive.

What I need is a simple macro that when clicked, will pull the most up to date data from the other workbooks to the MasterSheet. The majority of the time the other workbooks when I am trying the updata links in my Mastersheet.

I have tried various Macros that always seem to give variations of 1004 error.

Can anyone give me something that will work 100% of the time?

THis is the latest one I have Tried:
Sub updatenow()
ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources
End Sub