I would like to create a summary page showing 3 months's data contained on a
second sheet in my Excel workbook.

The 3 month summary table should summarise:

All the Mon 8:15 data for the 3 tables
all the Tues 8:15 data for the 3 months etc etc.
Then all the Mon 8:30 data for the 3 months etc. etc

The column headings for January in Table 1 are:

Time Mon Tue Wed Thur Fri Sat
8:15 237 287 269 etc
8.30 123 456 etc
etc

The column headings for February in Table 2 are:

Time Mon Tue Wed Thur Fri Sat
8:15 269 197 262 etc
8:30 etc

The column headings for March in Table 3 are:

Time Mon Tue Wed Thur Fri Sat
8:15 186 291 267 256 etc
8.30 269 197 262 etc

What will be the easiest way to accomplish this? A pivot table? If so how do
I create one? A macro or visual basic script?

Many thanks!