Warehouse management VBA

Hello, I am currently working for an association (which is delivering free meals for poor people) and i am trying to develop an application for their warehouse management. I have created 2 userforms

1) one for the input of products with several controls (date, type of product, supplier...)

2) one for the output of products with similar controls.

I managed to write te code to transfer the data for the forms to 2 sheets (input/output).


I need some help because I would like to have the current stock and be able to sort the data according to several fields (by product type, by supplier, by dates,...). I created several command bouttons for that.

How can I do that ? which tool should I use? with the automatic dynamic table, its a mess...

I can attach my file if required.

Thank you in advance for your help.

NB: its pure voluntary work, not a penny involved.