I have about 300 sheets in one workbook. The first sheet is named "Cumulative Data" and for each row I would like to pull specific data from one worksheet. The second sheet is named "soldList" and in Column J has a list of all the names for the other 200 worksheets. Each one of the worksheets has different data in it and each data is not in the same location from one worksheet to the next. For example, the buyer's name in worksheet 1 could be in row 30 and in worksheet 2 it is in 15. Is there way to make a macro to do a vlookup for the same information on each sheet and put in the cumulative data in the same column. For example, if I want to get all the Buyer's name from all the worksheets and put it in column B in "Cumulative Data" worksheet.