Insert rows into existing spreadsheets.

I need rows inserted into spreadsheets. I have multiple temp spreadsheets containing information - the sheets are named by a combination of characters and date. Every one of these temp sheets needs to be processed. In each temp sheet there are many rows. Ignore row 1 as it contains header information. When a row is read, a lookup is required on a MASTER sheet using a concatenation of the character portion of the sheet name and the data found in column 1. The lookup will be on a concatenation of data found in columns 1 & 2 in the MASTER sheet. If the lookup is unsuccessful the row is ignored. If the lookup is successful then the data found in column 1 is concatenated with the data found in columns 4 & 3 of the MASTER sheet. This is used to open a spreadsheet and, if found, the row from the temp sheet being processed is added to the sheet just opened. Change the date to DD/MM/YYYY, save the sheet & close it. Read the next row from the temp sheet. An e.g. of the data is shown: ABC_20110325 is a name of a temp sheet that needs to be processed. It contains the following data: Col 1 Col2 Col3 Col4 Col5 Col6 Col7 A1MN 25-Mar-10 20.5 21.87 19.0 19.61 25 AX 25-Mar-10 751.5 770.58 743.2 758.41 330 BBN 25-Mar-10 51.5 70.58 43.2 58.41 125 MASTER contains the following data: AX ABC NM3 F:\Project\ NAE CX AZS F:\Project\