Updating Pivot table using count and sum option from multiple sheets

[Thanish]

Hi Team,

I have 15 members in my team and they are updating their volume details for each sheet (I created one sheet per member)

I have to create a summary with the help of pivot by using all the sheets(sheets will have same titles).

Person1 Sheet will be

Name	Book ID	Book Title	Pages Count
Person 1	A123	Title 1	66​
Person 1	A315	Title 2	77​
Person 1	A835	Title 3	72​

Person2 Sheet will be

Name	Book ID	Book Title	Pages Count
Person 2	B345	Title 11	85​
Person 2	B962	Title 12	96​

Like above it will go for 15 members and i need the pivot like below

Person Name	Count of Books	# of Pages
Person 1	3​	215​
Person 2	2​	181​