Is there a way to use VBA in a master workbook that opens all workbooks in a folder then creates a new worksheet then pastes 10 headers in the new worksheet then pastes a formula below each header then closes the workbooks? I hoping the VBA code can do each workbook one at a time.

Thanks