Thank you for your reply, however I have the names still as Sheet1, Sheet2 etc in the worksheet, so it works along with the code, but thanks for picking up on that. My main issue is that I need a line of code that will only look at the Sheet I am tabbed into, rather than working for the whole workbook. As obviously the values for each sheet will clash of what action to take. So far, I can only have Sheet1 Copy and paste the row, and keeping all of the information in the same columns, but being pasted into the correct row so there are no blank rows.