Autopopulate data into different sheets

Hi, welcome to the forum

Your english is very good, and your explanation is easily understood

This is how I would takle this.

1. Use this in Raw, D2, copied down...
=C2&"-"&COUNTIF($C$2:C2,C2)
This will give you a unique ID for each Item and room

2. Use this in D1 in rour "room" sheets (you can actually put it anywhere and hide it if you want), it will pull out the sheet name for you...
=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)

3. Finally, use this in eacg room sheet, copied down and across, to pull in the necessary data...
=IFERROR(INDEX(Raw!$A$2:$C$22,MATCH($D$1&"-"&ROW(A1),Raw!$D$2:$D$22,0),MATCH(A$1,Raw!$A$1:$C$1,0)),"")

By the way, it will make things a LOT easier if you use the sane name for the room sheet as in the RAW table...Room 1 has a space in teh table, but room1 has no space in the tab name

#FDibbins, thank you for your kindness.

So, formula from #1 and #2 work just fine but formula from #3...where should I put it in Room sheets? Because nothing returns me (probably I'm doing something wrong).

L.E.: also I was wondering if is possible that Room1, Room2, etc sheets can be automatically updated if in Raw sheet I insert more records.

Thank you.

L.E.2: Solved! I did something wrong in first place and that's way nothing returned me on #3 formula. I also managed what I second want (updating every sheet when I input/delete records into Raw) by creating tabels. Is working like a charm.

Once again, thanks FDibbins.

I think maybe you missed my last comment about the tab names being exactly the same as the names in your data sheet. See the attached

Great job, well done and thanks for sharing