I have 10 work sheets in excel. All the work sheets has the same same fields. I want to combine all the work sheets in once spread sheet. In some work sheet in between rows are empty. If it sees empty rows it stops there. The rows after blank are not combines. Finding hard to modify the macro...