I have been trying to come up with a code to create a pivot table that analyses data from two different worksheets i haven't managed. I only have a code that uses one worksheet. The data in the two worksheets are the same, that is, they have the same number of columns. The reason for using two worksheets is because the number of rows exceed the limit of 1048576 (Excel 2007). If anyone has a solution to this, please help. Below is the code that am currently using. Thanks a lot

cntRows = Sheets("copy").Cells(Rows.Count, "A").End(xlUp).Row
Range("A1:D" & cntRows).Select
Selection.Name = "Items"
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:="=Items", Version:=xlPivotTableVersion12).CreatePivotTable _
TableDestination:="copy!R1C6", TableName:="PivotTable8", DefaultVersion _
:=xlPivotTableVersion12
Sheets("copy").Select
Cells(1, 6).Select
With ActiveSheet.PivotTables("PivotTable8").PivotFields("IMSI")
.Orientation = xlRowField
.Position = 1
End With
ActiveSheet.PivotTables("PivotTable8").AddDataField ActiveSheet.PivotTables( _
"PivotTable8").PivotFields("Count"), "Sum of Count", xlSum
With ActiveSheet.PivotTables("PivotTable8").PivotFields("Start")
.Orientation = xlColumnField
.Position = 1
End With