copy last row to next available row on other sheet

[roth_nj]

i am trying to make a spreedsheet to help me organize some stuff here at work. we have a bunch of overlays stored in several different locations. on top of that, they are all customer specific. there is also 8-10 cells worth of info describing each one.

in my book, i have several sheets, one for each customer along with one contaning everything.

i wrote a macro trying to copy a line from one sheet and pasting it into the all sheet. the problem is, its copying from the same line every time and pasting into the same line every time.

i want it to take the last line added into a customer specific sheet, and then add it on to a new line in the ALL sheet.

then at the end, i want it to re-sort all rows in order.



attatched is the test sheet ive been working with.

thanks in adavance

nick