I have an EXCEL sheet that I need help with?

There are two options for you : either 'VLOOKUP' Formula or through PivoChart and PivoTable Wizard.....

That's it...

Manikya

First put all 6 worksheets into the same book by just copying the tab at the bottom and adding it into one sheet. After all 6 are in the same sheet create a new tab labeled supplier or what ever. Reference the cells in the other 6 sheets that contain the information that you want on the supplier sheet. Create headings and areas that represent the info for easy interpretation.

yes, but it may be a pain

are the 6 worksheets in the same file?

open a 7th sheet and link whatever tiles you need to the other pages data, it's kinda like doing formulas and such, just between pages.

There is lots of things that Excel can do but without further insight as to what you are exactly trying to do, it will be hard to pinpoint the exact method. More than likely, you will be using data reference and IF formulas.

I can't visualize how you have your data layed out in each of the customer worksheets but here's one method that WILL work if my assumptions are correct:

1) assume that you have six sheets called cust1, cust2, ect.

2) assume also that the data you want in each sheet contains the following data for that customer:

A1: address

A2: phone

A3: Fax

A4: annual sales

Create a new worksheet named Client (for example)

and use the following formulas in the following cells:

in cell A1 use "=Cust1!A1" (without quotes)

in cell B1 =Cust1!A2

in cell C1 =Cust1!A3

in cell D1 =Cust1!A4

in cell A2 use "=Cust2!A1" (without quotes)

in cell B2 =Cust2!A2

in cell C2 =Cust2!A3

in cell D2 =Cust2!A4

do the same with Cust3 thru Cust6

Resulting composite table will be

Cust1....Address...phone...Fax...Sales

Cust2....Address...phone...Fax...Sales

Cust3....Address...phone...Fax...Sales

Cust4....Address...phone...Fax...Sales

Cust5....Address...phone...Fax...Sales

Cust6....Address...phone...Fax...Sales

You can decide how you want to indicate the customer name.

Hope that helps

Yeah, make a 7th sheet and copy and paste the info on to it... call it 'summary' or somehting exciting like that! You could use Macros to flick between sheets

Hyperlink.

VLOOKUP. It does everything!