Copy all the cells automatically to another sheet

[shaahmed]

I need help. I need to figure out how to pull <vb_highlight>data</vb_highlight> from one spreadsheet and get all of the information in the row only if it contains a <vb_highlight>specific</vb_highlight> word in a different worksheet. How can I do this?
eg: first sheet named as entry and I enter A1 = month B1= name C1=Age D1=salary and I have there 12 month worksheet name as January, February, March, etc. I need the first page entry month column is January so I need all other cells that means B,C,D are copy to worksheet January if there is February so copy to Worksheet February



Please help me

 

[Rick Rothstein]

Actually, remember this one instead (same concept, but slightly shorter)...

months = [TRANSPOSE(IF(ROW(1:12),TEXT(28*ROW(1:12),"mmmm")))]

Even shorter yet (and two function calls less as well)...

months = [TRANSPOSE(TEXT(28*ROW(1:12),"mmmm"))]