VBA Import Column Based On 5 Criteria

There is probably a simple way of doing this in excel but the only way that i can think of doing it is through VBA.

There are about 25 columns and 4000 rows in my spreadsheet. I want my macro to look up 5 criteria in Sheet 1 and the same 5 criteria in the previous years spreadsheet. If all 5 values in Sheet 1 match all 5 values in Sheet 2, i want it to import a cell's value from that row in Sheet 2 to the active row in Sheet 1.

Here is the code I have so far:

Code:

Sub Import2012Numbers()
Dim BlockNbr As String
Dim Position As String
Dim Scenario As String
Dim LOA As String
Dim ScenVal
Dim x As Integer

[Code] ...

I think i've got everything down in terms of the variable definitions etc, but i think the problem is coming from the order or method of the for each and looping process.

I need the macro to take A2, S2, U2, W2, and V2 in Sheet 1 and look through all the rows in Sheet 2 to see if any of the rows match all 5 criteria. Only then do i want it to move on to A3, S3, U3, W3 AND V3 in Sheet 1

When i step through the code i keep getting the error message "Next without for" for i, or "For command already in use".