Open Workbook in background, Copy Data, Paste in another Workbook

[popcorn7]

Hi guys,

I am trying to get a Macro to open up an Excel Workbook that would be saved in a folder always in the same path, once opened copy a range from it, and paste it in a 3rd workbook where there is a Master table that consolidates it all. Essentially the macro I am trying to create would be auto updating this Master table workbook in the background.

[popcorn7]

Moderator please delete 1 of the double posts