Instead of creating separate table for each unknown table. Why don't you try create one table named META_TABLE for all such tables and add all amount field into that one table?
You can opt below approach!
CREATE TABLE META_TABLE
(
TABLE_NAME VARCHAR(100),
NAME VARCHAR(100),
AMOUNT INT
)
INSERT INTO META_TABLE(TABLE_NAME, NAME, AMOUNT)
SELECT 'table1', 'a', 40
UNION ALL
SELECT 'table1', 'b', 60
UNION ALL
SELECT 'table2', 'a', 150
UNION ALL
SELECT 'table2', 'b', 50
SELECT TABLE_NAME, SUM(Amount)
FROM META_TABLE
GROUP BY TABLE_NAME