循环遍历文件夹，对每个工作簿复制粘贴一个范围到一个静态工作簿

I am trying to loop through a list of workbooks, and then for each workbook copy and paste several ranges on a worksheet in the current workbook to a master workbook. I am trying to loop through a list of workbooks