relate data from multiple sheets

Hai,
i'm really2 newbie. i need to design a form using excel. that form would contain 4 tables and put in separate sheets (that means has 4 sheets). each sheet/table is related.

Example:
1st sheet contains data about a company (name, address, phone no & etc.). In the sheet 2, it shows data about product ( name, price, category & etc.) including its company name (related to sheet1).

When user clicks on a company name in Sheet1, the VB will popup and show details of the company including its product list.

That's same goes in Sheet3 and Sheet 4. But i think if i can learn or study or get familiar with 1st process, i manage to handle the rest processes. I really2 hope that someone can guide me to accomplish this task.

Here is a great article about using MSQuery to create relationships between excel tables. http://www.exceluser.com/explore/msquery1_1.htm

You may not need to go that far. It sounds as if you may simply need to familiarize yourself about dependant lists. http://www.contextures.com/xlDataVal02.html

Thank You for the tips.

but is it possible if i want to use macro in this problem? because i don't want user thinks difficult since there are more than 30 field required.

Thank You for the tips.

but is it possible if i want to use macro in this problem? because i don't want user thinks difficult since there are more than 30 field required.

If you are looking for a code example, please provide more details. Where is your data? Range addresses. For example,

"1st sheet contains data about a company (name, address, phone no & etc.). In the sheet 2, it shows data about product ( name, price, category & etc.) including its company name (related to sheet1)."

It would be great if you could post an example of your data. See "Manage Attachments" below. When a user selects a company name, a form will show containing company details. Are these details to be viewed only? Edited with the source worksheet being updated?