Hi -- I asked this question a few days ago and only got a partial response. I think it's because I made the question sound more complicated than it is.
I am trying to pull the data from all the sheets in a workbook into a single summary sheet. Block pasted one under the other.
I would like to have the name of the spreadsheet from which the record came in front of each record in the resulting workbook (i.e. in column A) So if record "Apple | 7 | tasty | red" came from sheet "Bob Smith", the resulting record should be: Bob Smith | Apple | 7 | tasty | red
I would be very grateful for any help with this. Kind of a rush!