Excel expertise needed

I need to find a way to automatically import the data from the MAY 2006 template to the various other templates that start with 2 letter code. The lay out can be completely redone. I have about 20 files similar to the ones below that start with BL,CT and EH need to figure out a way to import the data monthly from the MAY 2007 spreadsheet to these. I am ok with them being reformated or re designed Thanks