Pulling data from multiple sheets and providing a summary

Hi,
I am an Excel novice and would like some help with my spreadsheet. I currently have a purchase tab, a sales tab and a stock tab. I would like to pull information from each of these tabs based on the product clicked in the directory tab.

For example, if I click on Mushy peas I would like the spreadsheet to pull columns A, C, J - O from the purchase tab only on the rows which have the product mushy peas in them.

The same applies to sales tab but columns A, D, K - P.

And finally column G in the stock tab.

I would then like this information presented somewhere so I can see the total purchase balance, the total sales balance and the current stock so I can see how much free stock we have to sell.

I am open to suggestions if anybody knows a better way of creating the spreadsheet and the information I require.

A friend recommended a VBA script with a userform but I haven't got a clue where to start to create this.

I have attached the file I am working on.

Your help is greatly appreciated.

Regards