Macro to referencing the same cells in multiple workbooks (200+)

Hi, I hope someone can help...

I've got a folder called 'Style_Analysis' which contains multiple worksbooks (approx 200, and this could increase) - each excel workbook in this folder is named in the following format
= 1 letter + 3numbers - 4 letters - 4 numbers _ Colour
(E.g. 1AAA-AAAA-1111_Colour.xls)

The file path for the workbooks is:
H:\Work\Custom\EB\FF\FLM\Style_Analysis

I want to reference the same 4 cells in each workbook and get the data from these into 1 summary sheet e.g. I want to reference cells BJ1, BJ2, BJ3 and BK1

I want the data to be returned in a table like this:
Style Cell BJ1 info Cell BJ2 info Cell BJ3 info Cell BJ3 info

I want the style column to pick up the the excel file names in order that they appear in the 'Style_Analysis' folder so that as new files are added to this folder, these summary sheet automatically updates with the new file name and the relevant cells information

Is this possible to do using a macro? I'm not good with macros as I don't really understand them so any help would be greatly appreciated as I really don't want to have to open each folder to do this manually!

I hope this makes sense..? Thanks!