Just a random question here, what exactly are you trying to do with these
separate sheets that couldn't be done with a filter or a pivot table on 1
sheet?

"Leo" wrote:

I'm going to try and word this the best i can

I have an excel spreadsheet with marketing leads on it. The header fields
are Company Name, Company Contact, Phone number, Company Location, and
Industry.

They take up the A1 - F1 fields.

I have lots of information there. Today I created another sheet with 4
industries on it and used that to make a drop down menu for the industry
column. So now all of my marketing leads have one of these drop down values
in it.

My question is this. How can I make it so that I can have a seperate tab
(sheet) for each industry with the leads for thhat industry displayed and
nothing else that updates everytime I add a new lead and industry into the
main information sheet?

Lets say I ad SBR Riders as a marketing lead, they are in the motorcycle
industry (which is one of the options), i'd like it so that they are
automatically shown in the motorcycle industry tab.

What function is this?

THANKS!