How do I make excel sort items on different tabs automatically?

You can do what you need with VBA but it's a little much to go into it here.

Personally, I would recommend you use a pivot table with the Info column as a page filter, date in the row labels and numerical value in the data items.

It's much more flexible that way. You can have as many subtotals as you want, maintaining the original data is only done in one place (for example, if you have to import new data each week or something - it only goes into one sheet). Also, you would be able to create groups on the date very easily (so you could analyse the value by month, week, quarter, year and so on).

If you're not comfortable with pivot tables, I can't recommend them enough. Get to know them - they will save you a LOT of time.

http://office.microsoft.com/en-us/excel/results.as...

Yes there is but it's very long and complicated. You can use worksheet formulae to do a sort, such as a simple bubble sort. The downside is that you need to put a lot of formulae in a lot of cells - if you have n items in the list then you'd need n*n formulae. Or maybe n*(n-1). I'm afraid it's too complicated to go into here. I've seen it done in World Cup (soccer) spreadsheets, so you might like to search for one of those. There may be a way of doing it using spreadsheet events as well - as soon as data is entered into the sheet, it triggers a macro which runs the built-in sort function - but I've never tried this before.