Hi Maam/sir. I want to help you complete the data extraction for you. I have done similar project in the past which involves extracting all the supplies within each category. Example, Bond Paper and Ballpen will go to Office Supplies Inventory Sheet while Paint, Nail, Metal Bars will go to Construction Materials Inventory Sheet, etc.
The use of combination of If, row, rows, small, and other functions in excel will do it.