Not sure what I need - (un)hiding rows, recreating tables & automatically adding data?

Edit: Actually, is there any software out there that can manage information/orders like this?

Hello,

I've tried searching around but couldn't really find the information I needed. I did see that we're able to use VB in spreadsheets, and I've had some previous experience with VB, though I've forgotten a lot. Anyways, I have a workbook with four different sheets. Every month I gather different customer orders, and products may be different from previous orders. Here's an example.

1st sheet: Current Orders (current orders of the month)
2nd: Customer Information
3rd: Past Orders (similar to the 1st sheet, but shows all from previous months)
4th: Products (lists all the products that have been ordered along with their costs, who ordered, which lot/order, etc).

excelhelp1.png

In the "Current Orders" worksheet, you can see some tables and a yellow background. I'd like to be able to be able to hide the rows in yellow, but be able to quickly unhide them with perhaps a button.

How could I also quickly create the same formatted tables when needed without having to copy, paste & clear data? Would I be able to do that with a button or something, and have it have just one line to enter products? If there was more than one product, could I press enter and it would extend the table?

I'll just start off with that for now. I also need some help with automatically adding new data to the Customer Information sheet from data from the Current Orders sheet if there's a new customer.

Thanks a lot!

Example screenshot + workbook attached
ExcelHelp.xlsx