I am trying to filter a database based on certain criteria without using the
autofilter function. I have a master data sheet that lists all my customers
and the types of businesses they are. From that master tab, I would like
separated tab for each type of business. Is there a formula I can use to
look up from this master sheet and sort based on the criteria without using
the autofilter button? The problem with using that is I would have to copy
all the data multiple times, creating a much larger spreadsheet than what it
needs to be.

Any help would be appreciated.

Thank you,
Peanut