How can force information to be entered in cells in a specific order

Can you use a VBA macro On Open which selects the 1st cell that needs data entered.

Then, when exiting that cell, use a macro that tests that a value has been entered into this cell, and if blank, return to the same cell until an entry has been made.

After an entry has been made, you can select the next cell to be selected either manually or automatically.

Do the same test on the next cell. On your macro, be sure to code using the activecell, don't hard code that address of the cell and that way you can use the same macro for all cells.

If you have a button (macro) to do something with the data you are entering, have the macro verify that all cells have been filled in before the macro will run.

Hope this helps