I have 3 sheets:

Sheet1: Stocks (many location, so partno can be repeated)
A B C D
partno Location Qty Value

Sheet2: Sales (partno mostly repeated because of sales on many dates)
A B C D
partno Date Qty Value

Sheet3: Backlog (partno unique)
A B C D
partno Date Avail Qty Value

I need to combine the 3 sheets into one: (partno will be unique)

A B C D E
F G H
partno stock qty stock value sales qty sales value Date
avail backlog qty backlog value

Which application is more suitable? Excel or Access?

How to do it?