How can I create a macro for extracting data from multiple workbooks within a folder

I have a number of workbooks in one folder. I want to extract data from a specific cell from each workbook and paste it into a table in a new workbook within the same folder.

The cell containing the data has the same co-ordinates in each workbook.

For e.g. if I have 5 workbooks and the data is in a1 in each workbook, I want to create the following table

Workbook Data from cell A1
‘filename 1’ Data 1
‘filename 2’ Data 2
‘filename 3’ Data 3
‘filename 4’ Date 4
‘filename 5’ Data 5


How can I accomplish this?