Order Sheet direction

[aclevela12]

I am only linking Googlesheets as my laptop with excel I cant get until tomorrow and this is for you to view to see what I'm hoping can be done.

Ordersheet

Pen Kit Description,Order #,QTY,Expiry 1,Expiry 2,Order Item A,123,1,Mar-21,Mar-21,Yes,Button or something ? whatever is easiest under the order cell Item B,456,2,Apr-21,Apr-21,Button or something ? whatever is easiest under the order cell Item C,789,3,Feb-21,Feb-21,Button or something ? whateve...

docs.google.com

Basically Im looking for a tracker and order sheet in one for a couple kits/bags.
It will have the item description order# quantity and expiry of 2 bags and then a checkbox or button under the order tab, when clicked it would populate under the "order"tab and unclicked it will be removed from that tab.

In the order tab it will have the items from first two kits that had the order button checked, a CLEAR button that will uncheck any boxes that were checked in the other tabs under the order column.
The other button will be like "EMAIL" which will open up outlook with a prefilled out email to a@a.com with the title"Order" and the body will consist of something like:
Good Morning
Please order the following:
the contents from the order tab
Thanks

My question is, is this possible to do within excel? How can i accomplish this? What should I look into?

I appreciate any help I can get, I feel like its a simple concept but not sure its so simple to implement(maybe it is?)

 

[EFANYoutube]

Hi aclevela
All the above is possible with a good understanding of VBA code and Excel inserted objects
Another way is by creating Excel User form and writing code to do it

Left of field and the far superior option for making this work would be an Access database.

Thanks
Excel Fan