Search, Select, Copy, and Paste Specific Data

[stpeter]

Hello All,
Can someone please help me with this?
I have a workbook with a tab that contains a total inventory (Main). I want a formula that will search the rows from tab Main, and return the full row of that information. There is an attached sample sheet. So, under Tab Red, the cells should copy and fill in all rows and columns if there is a "Red" in Tab Main. I can't use links as the number of Reds is dynamic and so can change and links will return wrong information. So Tab Yellow, Cell A2:G2, should return the data from Main A11:G11.
Again, the number of Room Colours or Room Numbers is subject to change, and so the changes should be accurately pasted into the respective tabs.
I hope this makes sense.
Thank you.

[FDibbins]

Try this ARRAY formula in A2, copied down and across. Repeat for each sheet, but change the sheet name (Red/Blue/etc)
=IFERROR(INDEX(Main!A$2:A$19,SMALL(IF(Main!$A$2:$A$19="Red",ROW(Main!$A$2:$A$19)-1),ROWS($A$1:A1))),"")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

[stpeter]

Hello Ford,
Thank you for your message. I did not receive a reply posted message and only upon checking saw there was a reply. My apologies for not checking sooner.
Your formula worked, however, it only pasted data into Column A. Can you edit your formula so it returns all the info for the respective row?
I've pasted the updated workbook,
Thanks,
SP

[FDibbins]

You just need to copy it across, like I said above No change needed

[stpeter]

I missed that , sorry
But it worked like a charm
Thank you very much Ford!