SQL insert script with table linking

My client is using MSSMS (Microsoft SQL Server Managerment Studio) to access a SQL database. They are rebuilding a software system that is moving two database systems into one. This is a urgent project and needs to be done tonight. You can not get access or a copy of the database. The project is to write an insert script from the two old databases into the new. Some information is needed from a few different tables of the old databases and into a number of tables in the new database and all tables link together. More details on the databases can be given to the winner of the project.