I have 20 workbooks and the main worksheet in each has the same layout. I
need to consolidate the inforamtion provided in these workbooks into a single
worksheet.

The data hosted in these files consist of text and numbers.

I need to consolidate this information weekly.