$sth = $dbh->prepare("SELECT `name`, `number` FROM ?");
for ($i = 0; $i < 5; ++$i) {
    $sth->execute($tableNames[$i]);
    ($name, $number) = $sth->fetchrow_array();
    process_data();
    #etc.
}