Select lines of data that contain words from column F drop down

I am trying to paste a macro into VBA that will select lines of data that contain the column F drop down "BRING FORWARD / À REVOIR" selection in sheet 2 to sheet 10 using the code below.
The idea is that I have a list of just the bring forward lines on sheet 10.

This is the error message I am getting.....Anyone familliar with it?

Please Login or Register  to view this content.

The hilighted error is

Please Login or Register  to view this content.

The problem was that the sheet was not named "Sheet10" I had renemed it