Importing Data from Multiple Excel Forms into Multiple Tabs in New Workbook

I had started a thread for importing data from multiple excel files: http://www.excelforum.com/excel-gene...ml#post3734721

I figured out that portion, but want to take it a step further. I would like to be able to have a selection on my excel form for which "category" the information belongs to... there are 4 categories "SC" "Todd" "PS" and "Contract" I attempted writing the following code but it only writes to the "contract" tab never to the other regardless of what input I have given for K3 on my form. So my if/else must not be functioning the way I intend. any guidance would be much appreciated.

Thanks.

Please Login or Register  to view this content.

Not sure I am describing my intent properly... I am trying to have the files be able to write into multiple sub -category tabs. in other words I want a summary page of all "Sc" forms, all "PS" forms, all "contract" forms, and all "todd" forms but dont want to have to presort them before running the macro. I want the macro to sort the information into the corresponding tabs on its own.

Sorry that I do not know how to better describe this.

thanks for your help!