Need Help Merging Excel Files into one sheet with different headers

[sesamecake]

Hello,


I am new to MS Access and I am trying to figure out the best way to merge 3 separate excel files into one. The issue is that they all have different headers but are related by product ID. The sales for the product ID are the same across all three, but I don't want to duplicate the sales dollars when I combine them.
Here is a visual of what I'm trying to do: https://imgur.com/a/nx9Fw
Thanks in advance!

[ranman256]

join all 3 tables on the key,
bring in only 1 Sales dollars.