New Data Consolidation Question
 

If my workbook contains multiple sheets all set up the same way...
ex: A=name B=address C=phone number D-Z is all different lists of items
One customer may take up many rows due to multiple orders in a day. Not each
time do I need to reenter the A,B,C fields.
Can I automate just the A,B,C columns (if all filled out only) to populate a
complete list of customers only? It can go into one cell I suppose using the
A&" "B&" "C type formula. Is there a way to make a running list without
having to filter page by page?