Get data from a closed workbook and put that on a another workbook (if is possible on a specific sheet)

[Gwhaou]

Hello,

Actually I'm trying to filter some data and dispatch them to other sheets by using VBA (this code works !). But to start the macro firstly I need to copy all the data from the source workbook and paste it on the macro workbook.
Is there a way to pull out for example Data (all the data) from the source workbook (the closed one) and paste it from the celle A2 by using VBA (on the macro workbook).

Hope to find some help.

 

[Gwhaou]

Have to precise that the source workbook name change every week, but the format remains the same. Is a way to select that workbook when the macro starts.

 

[Gwhaou]

Got the answer, please check this post : VBA to get data from closed workbook