How to move data from many tables to one table using stored procedure?

[Sjodin]

Hi,
I have two tables: "customers" & "campaigns" in an
admin-database.

Customers-table looks something like:
customerid | customername | billingaddress | databasename
3 customer1 mystreet cust1

Campaigns-table looks like:
campaignid | customerid | campaignname | tablename
14 3 '1s campaign' camp1

Then I have a couple of databases with a number of tables in each db. One database for each customer. All campaign-tables have the same columns.

In a seperate database I want to have one table with statistics from all of these tables.

Is this possible using stored procedures?

Thanks!
Magnus