Mac Excel help

Hey everyone,

I've got a question regarding formulas for excel 2011 on a mac. I am trying to compile a database for client information. I need to create a sheet for each individual client (28 sheets) and one sheet as a summary. What formula(s) should i use to manually enter data into the 28 individual sheet and have the summary sheet display all the data after manually entering it. Thanks for the help, let me know if you need more info.