Basically just need an equation that searches all tabs for a name and returns the highest value for the cell next to it on those tabs.

If anyone can help I can then fit everything else around it.