Sorting through multiple tabs

[Texas10]

Good morning,

Please see the attachment. I'm having some trouble having my excel sheet auto sort. In the sheet it shows locations A thru J. What I'm trying to do is get the information in those tabs to auto sort in the North Division. Currently it auto sorts the numbers correctly, however it doesn't correlate with the event title.

For example, if I go to tab J and put 99's in every category under tornado, it changes the cell value in the north division but it doesn't correlate with the event name in column A. So I need a code that it auto-sorts the event name with the cell values, if that makes sense.

Thanks again!

[dflak]

If you had the Events in the same rows on every sheet, the formulas you have would work. However, in the North Division, Tornado is on row 13, while in Sheet J, it's in row 19. I'm afraid you're going to have to either align all the sheets to be the same or use a summation of individual VLOOKUPS.