Split Workbook by Worksheets in Excel
July 05, 2017 - by Bill Jelen

You might have two reasons to want to split a workbook where each worksheet becomes a new workbook.
First, perhaps you just used the Show Report Filter Pages feature in Excel but need to send each sheet to a different department. To see how to use this, watch this Podcast 2106 starting at 7:58.
Or - you want to use the Power Query Combine Files feature but all of your sheets are in a single workbook. See the Power Query example in Podcast 2077. Or - you have some other business reason.
I recorded this video showing the free MrExcel Workbook Splitter:
Download the zipped workbook from here.