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

[Erusso]

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.

[Erusso]

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