Macro to collect data from Excel Form and populate multiple tabs

I need urgent help in arranging input from main sheet and populate other sheets arranged by year.

I have an Excel worksheet for collecting court cases and arrange by year. I have one main sheet called 'main'. The main sheet (main) is a form that collects various court cases from 2005-2012. Once the each case is entered, the user click save button, which saves the information in the sheets (all name from 2005 to 2012).

I can only save into just one sheet without arranging into years. I would like macro to copy from main sheet and paste in individual sheets based on the sheet name (year) and year entered.

thanks

Terry

Thansk JBeaucaire,

Here's attachment. The years in the drop down menu - when selected, data entered should be copy into respective sheets (tabs)It is very much similar to one of your sample files (sheet1ToSheets-ParseMacros.xlsm). My worksheet - the main sheet collects data for each year (year dropdown list from 2005-2015) and when button is clicked (save button) - it copies the data and save in the corresponding sheet (named years). Just like the Managers in your example. I try to upload file but the upload feature in this website doesn't work. It gives error 500. May be my browser. Any help will be great. It is

thanks much.
Terry

File attached.

thanks.

Terry

Nope...not working.

this will work

Set historyWks = Worksheets(CStr(Cells(7, 8).Value))

Yeah!!!! It worked... thank you so much, Rounakbhasin!!! Really appreciate your help.