I have several worksheets (each in separate workbooks) and I want to extract
one row (row 9) from each into a new worksheet. Is there a quick way of
achieving this or will I have to cut and paste. I would also like to have a
column in the new worksheet that contains the names of the workbooks on the
same row as the extracted data.