Help with code to determine which sheets to import using user input

[techkels]

Hello-

I'm very new to excel vba and am self-taught, so I apologize for any silly questions in advance.

I have multiple contractors who submit invoices to me monthly in separate spreadsheets, and I am writing a macro that copies from those spreadsheets in to a new master spreadsheet where each contractor has their own tab. I do not need to do this for every contractor every month, however, so I set up a listbox with each contractor's name so that I can select which ones I want the macro to execute for.

Here's my problem: I have several dozen contractors, and the only way I know of to tell the macro which contractors I want the code to execute for is by using several dozen If functions. Is there a different way to do this?

Thank you!

[stnkynts]

Would using Select/Case work better for you?

[techkels]

Thanks for the idea! That would have worked well, but I ended up using a For Loop.