Hey, i am making a excel PO forum for my company.

i've created a basic template, but was struggling with a few things.
I want to set it up like quick books, where after you log a po ( either saving it or opening a new tab),
a new template appears with the locked info (date, name, ect. cells) but i want the PO to automatically generate in a numerical order.

is this possible?

( i guess if thats confusing. i need help setting up a template that with every tab the same "po page" appears, and the PO number generates on its own)

Thanks. if that wasnt to confusing

( ps im a total novice at excel / computers so be gentle please)