Combining multiple worksheets into one sheet while data is different on each sheet

[acfl8199]

I need to know how to combine the data from the last 3 months into one sheet for the quarter

Example of sheets
A1: Customer Name
B1: Customer Number
C1: MTD Sales

Each month the customers name changes rows, depending on their sales that month. I'd like to consolidate each ones sales per month into one quarter sheet

Thank you so much for your help

[NumbersGeek]

Can you attach your file?

[acfl8199]

I dodn't know how to attach, but here is some data from each worksheet

worksheet1

gina 0004453 428.00
verda 0001682 425.00
wild 0011485 420.00
hair 0001280 396.00

worksheet2
olympia 0005867 440.00
carmichael 0000151 430.00
verda 0001682 425.00
gina 0004453 2228.00

worksheet3
justine 0005647 380.00
joan 0004641 367.00
la petite 0007888 360.00
charity 0011125 360.00

[NumbersGeek]

There is a button when you hit submit reply that says manage attachments.

[acfl8199]

Oh ok, great here you go

[NumbersGeek]

=SUMIF(Sheet2!$A$3:$A$6,quarter1!$A$3:$A$12,Sheet2!$C$3:$C$64)+SUMIF(Sheet1!$A$3:$A$6,quarter1!$A$3:$A$12,Sheet2!$C$3:$C$64)+SUMIF(Sheet3!$A$3:$A$6,quarter1!$A$3:$A$12,Sheet2!$C$3:$C$64)

Is a very long version of one solution.