I'm not totally sure that it's possible to do this but, I can't find anything specific that tells me how.

I want to create a running total on a separate worksheet that will sum the numbers from certains cells only if a string in a cell is equal to it.

For example:
Sheet 1

A1 A5

0101 $10.00
0102 $12.00
0103 $13.00
0101 $15.00

So on the total sheet I would want it to recognize the A1 strings and then run a total of all of A5's even if I were to all new numbers to the total.

For example:
Sheet 2

A1 A5
0101 $25.00
0102 $12.00
0103 $13.00


Sorry if I'm not being clear, I'm trying my best explain what I'm trying to do.