I have made a 'Data' worksheet containing many records with info on Date, Customer, Total.

I have used 3 Pivot tables on seperate worksheets to make: a sum of the Daily Totals, sum of the Monthly Totals, and a sum of the Yearly totals.

Because I'm new to Pivot Tables, and I dont know how to set it up to do it itself....
On the 'Data' worksheet I have had to Make 3 columns for each date so that each pivot table shows what I want. This is annoying for everyone who is entering new data.
It currently looks like this:
Column A Column B Column C Column D Column E
12.01.00 January'00 2000 P.Bloggs £35.00
34.05.02 May'02 2002 T.Thompson £35.00
12.01.00 January'00 2000 C.Cook £45.00
12.01.00 January'00 2000 N.McGregor £35.00

Is there a better way of doing this??