Need to automatically update sheet 2 as new data is added to sheet 1.

I need the Recon sheet to update as new information is added to the RawData sheet.

The Recon sheet sorts the RawData sheet by low to high BOL. The Recon sheet then looks at Columns F, G and H on RawData for an "x" in the appropriate BOL line. If there is an "x" a set value is put on the BOLs line on the Recon sheet.

As the month goes on new data is added to the RawData sheet and BOLs are rarely in numerical order. But they must be on the Recon sheet.

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

What do you want with the attached file? RECON sheet having some formula's which is exactly giving result as per your description. Now further what you need.

There are 5 rows of data on Raw Data sheet, however, the 5th row does not move to the Recon sheet. I have to manually move it. Is there a way to have the 5th and subsequent rows moved to the Recon sheet without me having to move them?

With a formula: copy, yes, move, no. Move will require VBA - shall I move your thread?