This is my guess to my problem.
I have data theat is in one sheet.
I have written some code to import data, and place it in row 5000, then I do a sort to consolidate the data. I then run a combine routine to consolidate the data. The cells in between rows 100-5000 appear to be empty, but I think something must be there. I do not know what because all I do is insert maybe 20 rows at row 5000. Reason is I do not currently know how to determine the current last row, then insert. Maybe this is a better approach.
I am including the Excel file.
Again, this group is wonderful, and I appreciate any support.