creating day of week trends from data sheet

[fmkjr]

I have a worksheet of data that I would like to create day of week trends without cutting and pasting... is there a way to have a sheet pull all the Monday columns, then tues col, etc?

thanks!
frank

Book3
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Day or Week Trend
2	Wed		Base	Base	Base	Base	Base	Base
3			Sat	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri
4	LOCATION ROLLUP		9/9/2006	9/11/2006	9/12/2006	9/13/2006	9/14/2006	9/15/2006	########	########	########	########	########	########	########
5	item 1		261	2,571	2,811	2,925	3,000	2,989	255	0	2,451	2,798	2,951	3,049	2,987
6	item 2		48.7	104.6	86.7	81.5	82.6	87.5	47.2	0	91.6	80	82.1	82.4	80.6
7	item 3		5.36	24.58	32.41	35.9	36.34	34.16	5.4	0	26.77	34.97	35.93	37	37.06
8	item 4		2.45	9.07	12.52	12.86	11.98	13.59	2.69	0	8.97	11.82	13.47	12.85	14.56
Sheet1