working with 3 sheets together

Hello,

I would like to know how i can retreive the information from sheet1+sheet3 in sheet2.

in sheet1 i set the name, email adress, product etc.
and in sheet3 i set the productname, price and productdescription.

In sheet2 i want to retreive the name + product from sheet1. and set the pricing, from the product described in sheet1. this is retreived from sheet 3

I have a small example.

Sheet 1:
- A2= Cola
- B2= Phillip
- C2= Bottle

Sheet 3:
- A2= Bottle
- B2= clean bottle
- C2= $ 0,10

Set this information in sheet 2:
- A2= Sheet1!A2
- B2= Sheet1!B2
- C2= Sheet1!C2
- D2= Sheet3!C2
- E2= Sheet3!B2

How do i get to let these sheets work together?

Book1.xlsx

I have added some things i dont know how to do yet

In a nutshell, when i fill in information in "Fill in here" i want everything to go automaticly.
Get the prices, information etc.

Hope this works for you

Hey Fotis,

thanks for the reply, but that wasnt really what i looked for.
I attached a new example, hope this explains better what i want/need.

hope this works for you fotisexample.xlsx

Did it have any use for me to make this new example fotis?

I want to work from 1 tab. From there on it should all go automaticly.