thanks man...

I wish them to be separate workbooks stored in shared location.