Sorry I apologize i might not be making things clear. what I want is in worksheet 2 to mimic what is input into worksheet one (without having to enter things twice). So when you input data across a row the exact same data will appear in worksheet 2. But the only difference is if the year is 2010 it goes into the 2010 section of the worksheet or if it is 2011 it goes into 2011 section.

I hope this makes sense? Not sure how well I'm doing at conveying my thoughts into words.