Hello, I have invoices eg 2007.36 John.xls, 2007.37 Steve.xls etc.. with the
same template format. I want to copy data from these into one spreadsheet
under different headings (Client name, address etc). I currently do it by:  
Client name (Cell A36) ='2007.36 John'E27, Client address(Cell b36) ='2007.36
John'F23  where E27 is cell for client nameand F23 is cell for client address
on invoice 2007.36 etc. but have to do this manually for each cell in each
individual workbook. I want to copy down the client name column, increasing
the workbook filename by one each time and keeping the cell displayed the
same- so Cell A37 will be ='2007.37 Steve'E27 .  I think maybe wildcard
characters but have no idea what to  do (without going into access and
spending 6months training)