Hello,
I apologize in advance if this has been asked before. I've found similar questions & results but based on different restrictions.
I receive a file from another company that has multiple sheets with sets of information that are broken down into three categories per sheet. I need a way to compile all of the lines of information into one sheet, but only lines that are under a certain category, and to put the sheet name that the line is from in column A. Shoddy example file attached. So essentially, from every sheet, I would need to grab all the lines of information under "Category 2" up until, but not including, the header row and the row at the bottom of the category that has a "Total", slap it together in a single sheet, and add the sheet name that it originates from to the left of the information. This would mean that "Category 2" would be a trigger word for the macro to start grabbing.
I'm unable to turn any of the information into actual tables or named ranges, as the files are sent from elsewhere, unfortunately.
Thank you kindly,