Display 1 row of data from many workbooks into new summary workbook

I have many workbooks (all formatted the same with like data living in the same worksheet within, with same cell references within each). The workbooks all live within a folder or subfolder of the main folder. There is one row in the same worksheet within each workbook that I want to display in another workbook. I realize that I could do this manually by creating hard links to exact filenames but this would be time-consuming because I have about 75 workbooks that I need to pull data from (and many cells of data to take). I also need to be able to reuse this tool to perform the same functionality again with different sets of workbooks that may be located in different top folder. That said, I know there is a more sophisticated way to do this without having to do it cell by cell with manual links to cells.

Example data (in Sheet called "Payroll" in each workbook, I want to display cells M22 through Y22 in a new summary workbook). It is basically a single row of data showing a number of scheduled hours. Taking the entire row of data is fine too (not specific cells) if that is easier.

Example data (in 11 cells in Row 22 of "Payroll" sheet) within 75 workbooks: 8.00 9.45 10.43 11.65 12.34 20.45 0.00 0.00 34.23 125.67 30.23

One row of data pertains to one workbook (one employee's data). The workbook file names have the employee name in the actual file name (so carrying the filename into the new workbook would actually be helpful information to carry to new workbook if possible) so then I will know which data pertains to which employee. Example filename JohnDoe1117.xlsx

The new workbook I want to create would summarize the data for all employees (one row for each employee (taking one row of data from one workbook affiliated with that employee), just taking the data from Row 22 of Payroll sheet and putting that data for display in new workbook.

The new workbook would have one row per employee. So if I have 75 individual workbooks, I would see 75 rows of data in the new summary workbook.

On final important note, if/when data is updated in the various 75 individual workbooks, I would need the summary workbook to automatically update (when it is opened).

I realize that it may be extra complicated to go read the source excel workbooks from various subfolders where they reside, but I appreciate any help or any direction that can be provided. I am not new to Excel but I am new to writing functions or using pivot tables (if that is what I need to do?) so if you can point me in the right direction or tell me generally what I need to do or give me rough draft code, I may be able to figure the rest out. Thank you!