Excel to multiple excel

Question

I have excel file with list of some companies in sheet1. And same companies in sheet2. How to split the data as companies wise for each excel. And sheet2 data to be also in that output excel.