importing large data into existing spreadsheet.

Hello everyone!
It's been a long long time since I've taken any type of Excel class so I'm beyond rusty on even describing what I'm trying to accomplish. I have a spreadsheet with around 25k rows and I need to import new price bands into 5 columns out of all these rows. Being a novice I originally tried to just copy paste about 15 or so at a time but the destination was in a filtered state and I couldn't do it this way. So I attempted to use Paste Buddy as it would let me paste selected rows/columns. Now this is where I'm stuck in choosing to ask for what direction I should take! I believe what I'm needing to use is a Power Query but I haven't figured out how to setup the source to the destination! I've attached a side by side of the spreadsheets to give an idea. I need to replace the Band 1-5 prices with the ones in the bottom sheet. Any advice would help at this point!
Thanks in advance,
Frank

I think PowerQuery (Get&Transform) is a good direction but from the picture it's hard to say what you should do.
Maybe it will help a little: Microsoft Power Query for Excel

It feels like I need to use a form of ??XXXX number sequence so that it will skip the BC in the product SKU then align the numbers to the corresponding price table. Whats a bummer is I know this was taught in my Excel class but that was nearly 15 years ago =/

I tried to say: without sample excel files (desensitized) I can't say more than I said

I've attached a small workbook that has the Cost Sheet for the sanded finish and the prices for the "Base Cabinets".

I went ahead and changed up the format a little. I removed some of the other finishes so it will only show sanded finish and the Base Cabinet tables.
Source = Product Master & BC has the Band 1-5 (B-F) figures that I need to move to the source tables columns (U-Y)

BC cannot be treated as source for PQ
1. Excel Tables & PowerQuery doesn't allow merged cells
2. BC data is not well organized. Each "table" should be on separate sheet.

I did Band 1-5 from Product Master on result sheet
is that what you want ?