Auto add and number rows in a worksheet and keeping format

Good afternoon

I have a workbook that i use to track our cake orders.
Now i have to keep adding rows to the worksheets because we are getting more and more orders. Now i have a VB Script that runs for those certain cell ranges. Everytime i add a row i need to modify the VB Script accordingly.

What i would like to know is how would i be able to do the following?

1. i would like to Have a work sheet with row A1:A14 visible and from A15 downwards hidden.
2 When data is inserted into row A14 in column "B" and "enter" is pressed, then it would unhide A15 and add a row .
3 Column "A1 downwards also needs to be automatically numbered when a row is added
4 If data in column B is deleted then it should remove that row and hide it and rearrange the number sequence accordingly

I really hope that makes sense?

If anyone would be willing to help, it would be greatly appreciated.
I have attached a test workbook to see what it looks like

Test Workbook1.xlsm

Regards,

Pkool

Morning Torachan

Thank you for your advice. The only thing is we don't have an inventory sheet as 90% of our cakes are special designs and are all quoted accordingly.
Will try find a way.

Regards

I will definitely do that. I am busy working on it now and see what comes up.
Thank you all for the advice. Only way to learn

Have a great day further.