I want to use VBA to gather data from sheets and place in 1 sheet automatically

[jrota]

I have a workbook with 11 sheets. 1 - 10 will be the individual data entry sheets. I want, that while the info is being entered into each sheet, the 11th sheet (master report) will automatically populate all the entries from all the sheets 1 - 10 and alphabetize names with their data. I will attach workbook. You will see very clearly all the sheets and type of data being entered. its a basic income and expense workbook. I will apply what happens here to a larger scale.