Have you considedred using only 1 sheet for ALL data entry, and then use other sheets for your summaries/extracts etc? This will keep data entry simple, and enable the use of some of the powerful analysis tools in excel (like Pivot tables)