Automaticly connect content from other sheets

Hi, I'm trying to solve one thing and I hit the 8192 character formula limit when I tried to bring up a formula. Basicly what I'm trying to do is:

1) I open the file and fill in cell C1 on sheet1 with a certain content
2) on sheet2-sheet7 I have content in all the cells a1-a50 and b1-b50
3) if the content from C1 on sheet1 is the same as any cell a1-a50 on sheet2-sheet7, then D1 on sheet1 should automaticly get the content of the b column. That means, if C1 on sheet1 is the same as for example A13 from sheet4, then D1 on sheet1 will automaticly be the same as B13 from sheet4

Probably I'm not really understandable, so I attach an example. I filled in C1 on sheet1. On sheet4 there are already filled the cells a13 and b13. A13 is the same as C1, so D1 will get the same content as B13.

Can somebody please help me what formula to write in D1 on sheet1, so I get the information in this case from b13 from sheet4? Thanks a lot in advance.

Hi Oeldere, well I made up seven lists, because this file is for a restaurant and on each list there is a different kind of food. So let's say list 1 are chicken foods, list 2 are fish, and so on. So I put each list of the same kind of food on a different sheet, so any time you can add other foods of the same kind to the list.

Then on the first sheet I have a validation list, where you can choose from all the lists:

1) the kind of food
2) which particular food

This all works well, but when you choose let's say "cow" and then in sheet 1 C1 "Wienerschnitzel", then I need to get automaticly also in D1 the price, which is next to the Wienerschnitzel somewhere on the list. Which is exactly what I mean now:

I choose let's say A13 on sheet 4, which is the Wienerschnitzel, but then I need to get the price, which is in B13 on sheet 4 to be automaticly filled in D1 on sheet 1, right next to C1 on sheet 1. Do you understand me? Is this possible? Thank you!

Hi FDibbins! Thanks a lot for your response. There won't be any duplicates in the list, so that's no problem, but I can't get it working. When I put the formula you wrote in D1, it says that this formula contains a mistake (or something in that way, I have a Czech language version), and I have no idea what the mistake can be. Could you have a look, whether the formula is correct to fill in D1?