Macro to identify a word in a given row and populate another tab with the same data

[pushruk]

i there,
I want excel to identify a word in a given row, and search the excel tab that has been named with the same word and copy paste the entire row in the tab on the next available row. For eg..

Row 2 in excel consists the words : DOC-MSFT-AAPL-2005.

I would like excel to find the word "MSFT" and find the tab thats named "MSFT" and copy past the entire row ie,..DOC-MSFT-AAPL-2005 in the next availabe cell on the excel tab "MSFT".

Any possibility of getting this done?

Thanks
Joe