Storekeeping macro

Hi guys, i'm writing you from Italy, hoping to find someone with enough wisdom and kindness to help me.

I know excel basics, so i will do all formatting work (sorting, underlining, etc...) but i really need your help for the main body of this future macro.

I'm attaching the preliminary revision of the xlsx for your use.
This is a xls for storekeeping management, this is already hand-filled with my output expectation.

I have three sheets:
- store (otput sheet);
- load (purchasing);
- offload (sells).

The purpose of the output sheet (store) is to collect all products and show the live quantity. The macro should recognize the product description and associated quantity and summarize from "load" and "offload" sheets, giving the output of the live quantity in store.
The macro should BUILD the "store sheet" including all the other infos in the other comlums (i think for the other infos it should be a simple copy/paste, but anyway included in the macro).

As i told before, the example xslx attached shows the macro expectation.

I know that several company sells softwares for this purpose but my boss is quite a cheapskate and he asked me to deal with it.

I think that for u guys, excel experts, this should be easy but i don't have any experience in VBA, i'm only quite capable of reading the codes and little editing.

I'm always available for further information/clarification, if in case.

Thank u all in advance.

Good Morning Bernie,

thank you for the answer.

I summarize here my thoughts/questions/conclusions:

- the MACRO returns a "runtime error 438", so it does not run till the end;
- I see that u removed the output sheet "STORE", is this because the macro creates a new one every time?;
- It seems (correct me if I'm wrong) that your macro edits also the sources sheets Load and offload, is it true?.

Thank you very much