Match cell value in wb1 with sheet in wb2, copy specific range back to wb1

I have two work Books.

In Book1 is a sheet "COSTING SHEET", in the Book2 I have many sheets with unique sheet names containing same categories (columns) but different volume (number of rows).
When in "COSTING SHEET" in cell B5 I type the unique name (that also exists in the Book2, if it doesn't than Msg Box "Doesn't exist") I would need a macro that searches for that sheet name in Book2 and copies the volume from that sheet to "COSTING SHEET" in order:

Book2 $C$7 copy to Book1 $A$5
Book2 starting at E7 copy to Book1 starting at B7
Book2 starting at F7 copy to Book1 starting at C7
Book2 starting at G7 copy to Book1 starting at G7
Book2 starting at H7 copy to Book1 starting at U7

(Apart from first copy all other contain same number of rows)

I appreciate your help!

Would be great if this "Adding" of copied data would enable me after typing in and confirming the first matching name and adding data from WB2, to type in another name and add it bellow the existing data on "COSTING SHEET".