Excel macro that collects data from files in directory - budget A$10

I would like to get a script that collects data from each excel file in a directory The script would prompt me to select the directory it would then loop through each excel file, selecting a sheet called "light" and then populate the sheet in the macro file with: the file name (in Col A) Cells A2-D2 from the light sheet (Col B-E) and cells A-D from the last row of data from light (Col F-I) the macro then moves to the next excel file and gets the same data and places it in the next row. Will provide a sample if not clear. Not a complex script, so should be done quickly.