How To Do Insert In Another Database When The Database Name Is A Variable

Hi,

We have different databases on the same server: Whrs001, Whrs002, etc. All databases have the same structure.

Suppose i have a table "location"
create table location
( location_id int not null primary key,
location_name varchar(50) not null )

I need to inserts data in "location" tables of different databases. But these inserts needs to be across databases. For example from the "Whrs003" database I need to insert data (location_id=123, location_name='markham') in "location" table of "Whrs001" database.

So my thinking is to defined a stored proc which has database name as an argument:
create procedure location_insert
@a_database_name varchar(100),
@a_location_id int,
@a_location_name varchar(50)
as
...

So for the above example the call will be :
exec location_insert 'Whrs001', 123, 'markham'


What would be the actual insert statement in this case? And what things i neeed to take care fo to make sure it always execute successfully?

Thanks