How do I make on cell equal another if a certain word is entered into it, also I need other cell to equal certain things after the word is typed?

I’m at a loss here, I need help.

What I’m trying to do is have a list on one sheet with names say in a column like A1 to A25 and then another set of cells with additional info in Like B1 to B25.
Now what I’m trying to do is have another sheet That I can just type the name in and when a name is typed in
a certain cell it will send the info to another sheet with the info in a cell and the additional info in the cell next to it.

I know it’s hard to explain but this would be the break down: A list of names in cell A1, additional info in cell B1 on sheet 1. Sheet 2 would contain different cells but say when I enter a name in cell F6 on Sheet 2. Sheet 3 A1 would show the name and B2 would show additional info, but if I change the name on sheet 2 in cell F6, it would automatically change the info on sheet 3.

I know if someone can point me in the right direction, I can figure out the rest of which I have to do. Thanks for any help someone can give me.

Do you mean something like this - DataOnSheet3FromSheet1BySheet2.ods?

Just got done, editing my sheets. It worked like a charm. Thank you very much.