How to create a packing list from a distribution list

[Night Worker]

Hi folks,

I have a sheet (sample attachd here) which contains data as following:

D1:K1 Names of books to be distributed to colleges
B2:B10 Names of colleges who will receive books
C2:C10 Codes for Colleges
E2:K10 Number each book that a college will receive.

How can I create packing lists from this data? I will input College Code in a cell and all book titles and their quantities need to be filled up in the sheet.

There will be one packing list per college.

Is it also possible to create separate sheets for each college? Further can the new sheets be named according to College Code, for example 102?

Any help in formula/functions/vb code will be appreciated.

Regards