@Matt Mickle had a solution that seems to fit my needs except for one aspect. In the destination worksheet, I would like to find out if it's possible to have the rows added in a way that automatically sorts them by a value in column A. That way, when I go to the "projects completed" worksheet (or whatever I end up naming it), the projects are all listed in numerical order (we number our projects numerically), even if they are not completed numerically.
Not that it matters, but I don't need as many columns as the original poster in my reference link. I need about 6 columns of data plus one column to designate the status.
If anyone could help out with that, I would greatly appreciate it.