Hello. I imagine that my question will require way more info than what anyone is willing to spend time giving but here goes. I receive via email several workbooks every morning each of which contains similar information but in different columns, formats, column headings, total number of rows, spaces between rows, etc... Not only are each of the workbooks different from one another but any given workbook is likely to be different from one day to the next. (Mainly just in the total number of rows, not arrangement of columns or formats.)

I would like to write a program that will create a list in a new workbook that consolidates the information from each of the source workbooks. On the new worksheet I would like to have option buttons at the left side of each row that I can use to select the given row. The information from the selected rows will then appear on another new worksheet.

I am having difficulty figuring out how to most efficiently write this program. How can I poplulate a worksheet (destination worksheet) with information from worksheets in other workbooks (source worksheets/workbooks) if the column headings in each of the source documents differ from one another. I could see using if...then statements in each column but given the number of columns there would be a ton of options. Also, because there are empty rows at varying intervals on each of the source worksheets I cannot simply have Destination Worksheet row 1, row 2, row 3... pull the information from Source Worksheet A row 1, row 2, row 3..., respectively.

Can anyone offer guidance. Thank you in advance if you choose to accept this mission.

Mr CST.