It's possible - but the query would be different each time a table is added or removed, and it's a very unusual thing to try and do - it almost certainly means that your whole DB design is wrong: SELECT commands are designed to return information from one base table, with addition information from other related tabled which share common information (normally via a FOREIGN KEY relationship).
Trying to return unrelated info from a variable number of tables is not really the same thing.
But if the ID is a common accessor, then you'd need something like:
SELECT a.*, b.*, c.*, d.*, ...
FROM Table1 a
JOIN Table2 b ON a.ID = b.ID
JOIN Table3 c ON a.ID = c.ID
JOIN Table4 d ON a.ID = d.ID
...
WHERE a.ID = 1
But as I say - if that's the case, it's normally your DB that is badly designed.