Beginner - VBA Copying data from sheet & range from several workbooks to a master via Teams

Hi experts! I have read several forum posts on using Macros to copy a specific range from one workbook to another. However nothing I have read seems to match my requirements.   The scenario is I h...