auto updating info from main page into 3 seperate worksheets

My problem is this:
We keep track of orders in Excel. What we are trying to do is when we update the main page, depending of the "code" we put in (laser, screen, embroid) it would then copy that order onto the corresponding worksheet. Is this possible?

Thanks so much for your help

Originally Posted by JBeaucaire

Each order is a single row on the "main page"?

I have a macro that may be "ready to use" for parsing rows of data from one sheet to many sheets named for the same values.

Sheet1 to Many Sheets

It not only can parse the rows, it can create the sheets if they are missing.

Yes. each line is a single row, 9 columns long. We will have a column that we will type our "code" and then want that whole line to be copied onto its corresponding "code's" page