I have a sheet that keeps track of our billing. The summary sheet has the
names of clients, what billing type they are, the amounts they pay per
month, who and where they invoices go to. all that information comes from
individual sheets within the workbook. Each month I have to send out
invoices to all the clients that have a certain invoicing level. normally
what i would do is copy and paste each one to the bottom of the page. Is
there a way that I can have the rows clients with a specific billing type to
be copied to another page or even automatically come up in a list if i use
data validation? (for example: on sheet 2, A1 would have a list of the
billing types and if i chose a certain billing type a list would form
below).

any help would be appreciated