I’m a retailers and I need prices and manufacturer in my master workbook

I get quotations from manufacturer and I figured out Power Query will be helpful

If make a query from a folder that has all my quotations, then I get a table as a result, but how do I make the prices according to their manufacturer names come up in my master workbook that I have?

My master workbook has my Product names, product name of manufacturer, and prices that I manually added in past few years, changing them whenever new quotation I receive

Do I make a power query in my master work book or I make seperate file with power query and use vlookup or formulas to get the prices according to products?

I would prefer the latter because my master workbook is in wps and my whole system is in wps

But in short I am confused how to incorporate this in my system

I own excel software as well