Thank you so much for your reply.
I ran the script and named the sheets 'LastYear' and 'ThisYear' as you did.
I keep getting "runtime error 9: Subscript out of range".
Debug highlights the line "Set s1 = Sheets("LastYear")".
I ran the script from worksheet S2.
Would be grateful for your guidance
Thanks again