Distributing work dependent on quantity to different locations

Hi all

i am stuck with a problem , i am uploading a file for clarity

DB.xlsx

Here i have 3 sheets, orders, database and output. In order sheet we will input orders(that i can do manually), database sheet has got all the information like quantity, stattion number, which department a particular size to go to.

The output sheet is the answer what i am looking for. I did it manually and i am looking for a vba solution.

thank you so much, much appreciated for your time

Regards
Gamz

thank you for reply royUK

I am open to changes , the database now has no empty rows, the output sheet has the information which is related to orders, if in order sheet a product quantity is 30, in utput sheet the items is multipied by 30, output sheet also contains other relevant information

DB.xlsx

for example 1 shirt is made up of 3 individual components
components qty

25 X 23 X 1220 7

100 X 85X 450 8

50 X 35 X 567 9

so if i order 10 shirts the the outcome will be

components qty

25 X 23 X 1220 70

100 X 85X 450 80

50 X 35 X 567 90

1 shoe is made up of 2 individual components


components qty

LACE BLACK 5

LACE WHITE 6

so if i order 5 shoes the out put sheet should have
components qty

LACE BLACK 25

LACE WHITE 30



i hope i am explaning itself clearly