Subscript out of Range ? Run time error 9

Can anyone suggest why I get a subscript out of range error 9 ?

My code is :

Please Login or Register  to view this content.

The macro is supposed to copy data in a Table on the IncidentsForm Tab, (Table currently has data in it from A3 to X17, table header is in row 2, and the table is called Input)
I want it to copy into a new line at the bottom of the data in the Incidents tab, and also a copy of the data into the IncidentsMaster tab and then clear the data.

I have triple checked the sheet names, and they are correct, so why is it not able to Set the Worksheet ?

Any idea's ?

Many thanks

Rich

Skullypots

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however we recommend that you include code tags around your code.

I have added them for you because you are fairly new.

Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Guideline #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here.