Have a worksheet listing products and prices for numerous suppliers.
eg.:

Supplier--Product---Price
ABC-------apple-----1.00
ABC-------orange----1.20
XYZ-------brick-----3.40
XYZ-------cement----0.80

This worksheet will change often.

What I would like is to reference this information on other worksheets. I would also split the info onto a worksheet for each supplier. Therefore i will have a worksheet for ABC and for XYZ, and the info in these worksheets will change as the main "index" worksheet changes.

eg.
Worksheet ABC contains:

Product---Price
apple-----1.00
orange----1.20

Worksheet XYZ contains:
Product---Price
brick-----3.40
cement----0.80

have looked at formulas, but this seems messy. Is there a VBA method that could automate this task?

Any thoughts/suggestions appreciated.