The title pretty much says it all, but I am creating a workbook that takes data from multiple worksheets in the same workbook and adds it to the first empty row in a static worksheet. In the static worksheet, the column restriction is from A to O and there is no limit on how many rows are affected; assume all of them AFTER ROW 2 can be added to. In the dynamic sheets, only columns A to O will be looked at, and rows 2 down to the last filled row. In addition, any time that data is added in ANY worksheet, it gets added to the bottom of the static worksheet.



If this doesn't make sense or if you have any questions, please feel free to ask!

Thanks!