Excel Get Data From Closed Workbooks VBA - part 2

I have updated one of my earlier videos to show how to copy an entire sheet from a workbook rather than just data from a cell within that file. So this video shows how to use VBA to open a file, copy an entire sheet into the current workbook, close the source file, and rename the sheet in the current file.