Your additions and deletions would need to be done by a macro.
Presumably there is some identifying key in each row.
The fourth sheet would use VLOOKUP functions to get the prices.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup