I have a workbook with multiple tabs (let's say 20) and each row of the spreadsheet has a company and some data for it. Also in each row is a cell that either says active or inactive.

What I want to be able to do is pull data from all the tabs of this workbook into a "Master" tab that lists out all the companies (and all their associated information) that are active. I want them to be organized by what tab they came from as well.

Could someone provide me with some guidance please? Also, if this is possible to do without a macro, then a technique to accomplish this would be appreciated.

Thanks!