This can be done pretty easily but because there are so many worksheets and they have a different names we would need a sample workbook posted. I am a little confused at to why the data would fluctuate when you say E3 to F2 and C2 to D2 I would figure it would all be the same row and then that would go to a result row and then continue till the worksheet was analyzed. After that it would go to the next worksheet.

Please post a sample workbook and I should be able to get this coded for you soon.

Thanks