是否有一种方法可以从多个表中提取单个行?

I need to pull specific information from Excel Workbooks with multiple sheets in them. (Snapshot below). I imagine it would be easiest to pull each row then count the quantity from there. The main issue is there are multiple sections in a sheet. I don't care which language is used as long as I can get the info, preferably onto a new sheet at the end of the workbook, but doesn't have to be, I need to get the counts the ProServices need to put together their financial model.I need to pull specific information from Excel