|Please read this How-To to see how to post data in these forums:|
Make sure to include Row Numbers and Column Letters.
Without having your sheets set up before hand
to automatically copy data from one sheet to another,
the only option would be a MACRO.
Unfortunately my macro skills are just above nill,
but there are others on the forum who are very adept at creating macro,
so post your data, as described above, add as much info as possible
and hopefully you will get a response.