Auto-copy cells one to another + formation too

Hi!

I want to make intelligent excel, like..

i have many sheets and i want it to work the way, that sheet2 takes data from sheet1.

so

1)
i want to build list of items in 2 rows on sheet 1

apple animal
banana fruit
cat animal
dog animal

2)
i want them automaticaly to copy to sheet 2 as with formula

3) if i align on sheet 2 them as animal and fruit ABC, then i want that that row 1 moves with them.

4) and i want that to sheet2 it copies sheet1 formation too, so "=X1" is not ok.

is it possible somehow? basicaly i want to build my database and i want it to be intelligent, automatical.