VBA code to write content of last cell in multiple workbooks to a control workbook

Every month I receive about 50 workbooks with different numbers of rows and columns, including many blank cells. I save each month's workbooks in a separately named folder. eg. Nov2021
I need VBA code to:
a. find the last cell in each of the +-50 wb's in the named folder;
b. find the name of that wb on a control sheet in a different wb;
c. if it does not exist, add it
d. write the content of the last cell in each of the 50 wb's to a new column on the control sheet.