Facing error when applying macro for pivot table concepts

Details of my macro:

macro that will move and total some data from 7 worksheets to a tally worksheet in the same workbook.
we have used a pivot table to do this.Due to difficulty of manual effort we are came with macro to do this.
I have included a sample of the workbook with 2 data sheets and the tally sheet.
for each customer number in col a I need it to copy col b,i,j,o and m.
I then need it to sum the total of col c from the store data sheet and put in col f of the tally worksheet,
sum the total of col d from the store data sheet and put in col g of the tally worksheet and sum the total of col e from the store data sheet
and put into col h of tally worksheet.
I then also need it to take the value from col c of the store data worksheet and put it into the corresponding store column in the tally worksheet (colj-colp).
there is a formula in col I of the tally worksheet for the ret % figure.
But my original workbook having 7 worksheets each named co1,co2,co4,co5,co6,co7,co8(all of will have the same layout of data)
that will be used to combine onto the tally worksheet

Note:

I have attached two work sheet.One is working fine <<customer.xlsm>>.I have applied the same code for the workbook <<customer workbook_reval.xlsm>>.
But am facing error while running macro.

Please help me to reslove this issue

Regards,
Lax

Dear naveed,

Thanks for the intrest to help..Am tried to..but am failing..But i want to run the macro in Customer Reval.xlsm only and this is my original file.Where i need to update the code and again again am failing when trying..Please help me boss


Lax

Dear Naveed,

I need to run the code for Customer reval workbook only.another one is a old workbook.If i want to run the code in Customer reval.xlsm means where i need to update the codes..

lax

Dear naveed,

We can skip that Ciy column.


Thanks,
lax

Sure naveed..Thanks for the kind words.

Dear naveed,

Thanks for the help ..it is working good..But one ques pls

What is the need of changing PivotTableVersion12 to PivotTableVersion14..I dint get your point..

Thanks in advance
Lax

Thanks boss..when i click add reputation star..it is showing msg like "You must spread some Reputation around before giving it to Naveed Raza again."..Please help me how to add.

Lax