I am fairly new to VBA and have not found a post that pertains to my particular question. I have a master spreadsheet that takes specific cells from multiple workbooks and worksheets within those workbooks. The master spreadsheet has a list of file paths that are input manually. I would like to create a code that loops through each of these paths, opens up the specific workbook, and copies and pasted various values from multiple worksheets into the master workbook. Some formulas (such as vlookup) will also need to be used within the code as the cell references may vary.

Thank you for your help!