Looking through multiple worksheets:

I multiple worksheets (at least . Each worksheets has the same data and
different data.

Example:
(Sheet 1)

A B C
1 Car 1 49
2 Truck 54
3 Bear 6 5
4 Ralph 9 4

(Sheet 2)

A B C
1 Car 2 5
2 Truck 55 4
3 Train 42 5
4 Ralph 3 8


I need to copy information into the new summary sheet from Column A. But, I
can't have duplicates. Something like If in A of all worksheets then copy
into summary A and If duplicate don't copy.

I then need to transfer the row data.

If data in column A of worksheets matches Column A of summary worksheet then
what is the sum of the information that matches in that row and column and
placed in the matching row and column of the summary worksheet.

So this (detail):

(Sheet 1)

A B C
1 Car 1 49
2 Truck 54
3 Bear 6 5
4 Ralph 9 4

(Sheet 2)

A B C
1 Car 2 5
2 Truck 55 4
3 Train 42 5
4 Ralph 3 8

Should look like this (summary):


A B C
1 Car 3 54
2 Truck 55 58
3 Train 42 5
4 Ralph 12 12
5 Bear 6 5