Creating a Customer List

I have customer data (name,add,city,prov,code,phone) organized in columns. I would like to create a customer list to export to a web page.
What is the easiest way to do this? I would like all the data to end up in Column A in the format

Customer ABC
111 Whatever Street
Wherever, ON N2Y 2RX
(555) 555-5555

This works for the first customer but I need to repeat for 300 rows.

=Customer!A3
=Customer!B3
=Customer!C3&","&" "&Customer!D3&" "&Customer!E3
=Customer!F3

Any suggestions ?

THX

I would like to transpose the data in sheet 1 to the format in sheet 2 for approximately 300 unique customers.


Sheet 1
Current Cust Layout

COL A---COL B-------------COL C-------COL D------COL E
CustA---101 anywhere-----anytown-----Ontario-----H4X 2E7
CustB---102 somewhere---dullsville-----BC---------V0G 1E5
etc


Sheet 2
Web Layout

COL A
CustA
101 anywhere
anytown, Ontario H4X 2E7

CustB
102 anywhere
dullsville, BC V0G 1ES

Thanks ... problem solved.