views - Mysql loop through list of tables to create summaries -

i have list of set of users in database. each user, there dataset stored separate table. these dataset tables have same name unique user id.

i know should have done made giant table dataset tables stored - i'll attempt modify project in future.

however, time being, how can create query loop through list of user ids, going through each user dataset table , creating set of, say, averages each?

i've taken @ stored procedures , views, not sure of best way start!

thanks!