Hey everyone. So I have an Excell workbook where the user keeps track of
his/her sales data, basically to have record of which accounts were accessed,
how many sales were made, etc.

Now before you ask, the company doesn't want Access :/

What I need to do is copy the information they put in (from A2:L2, all the
way to A21:L21, for each sheet (there are 14 sheets), and put it on a final
sheet which would be used for exporting purposes. Now we also need the
information to NOT copy if it's a blank row, and update on-the-fly. Is there
a method of doing this in Excell 2003/2007?

Thanks in advance, for any help.

Chris