Working with multiple sheets

I have a report whereby each work sheet represent a different week, however I would love to have one sheet as the master sheet whereby the information entered into the weekly sheet is automatically entered in to the master sheet. Is there a way to get this accomplished?

May I see a sample of your workbook with a sample of your master worksheet?