What kind of VBA experts do we have here?

Here's what I've got: 2 workbooks 1. WB1.xlsm <-- book with macro 2. WB2.xlsx

In wb1 I have a range - B8:B38, that could have anywhere from no valued cells to 30 valued cells (value will be variable Txt)

I need a macro that will search this range for all of it's values, then find the matching value in range - A2:A1000 of WB2 and transpose data from WB2 into WB1

Example: WB1: Cell B8 = AXXX
WB2: Cell A5 = AXXX
Copy Range - B5:U5 from WB2
Paste Range - B5:U5(corresponds to row 5, of A5 above) from WB2 into range C8:V8(corresponds to row 8, of B8 above) in WB1
repeat for all cells in range B8:B38 that contain a value