I have 6 cells, I'll call them A-F, that may or may not have data in them.
I want 6 other cells to check the first 6 for data.
If A is blank, check B and insert if not blank.
Then check C, if blank, check D and insert.
Any of the 6 could be listed in any of the other 6 cells.
If only C has data, then only one cell on the new page is necessary.
I A,C,E,&F have data, then 4 cells on the new page are necessary.
I want this to be automatic as data is entered in the first 6.

Hope this makes sense. Thanks for the help.