Help with copying data from cells in multiple workbooks to a master workbook

First of all hi to all the helpful kind people on this forum

I am new to the forum and this is my first post, i'm hoping some kind soul could help me with a problem I have.

I currently have a folder containing multiple excel files.xlsm all formatted the same only difference is the values of the data actually entered in each workbook see example below:

example A.jpg

What I want to achieve is to have a master workbook which when I press a button will open file dialogue so I can select the various workbooks I wish to import data from (data is only on Sheet1 of each workbook).

The data I wish to import from each workbook is below:

example B.jpg

And each time it imports the data from one of the workbooks it places it below the previous imported data on the master worksheet like below:

example B.jpg
example B.jpg
example B.jpg
example B.jpg

I hope someone can help with this as currently I am having a very laborious task of opening each workbook(20) in total and manually having to look at the data, so in theory I am wanting to create a sort of dashboard I guess.

Kindest regards,

James.