Auto-populate checked data from sheet to sheet

[holdenc]

I am using a basic excel book with many sheets holding reference data. What I want to accomplish is, as I go through each sheet and mark a column beside data I need to pull at that time with say an "X", how can I create a formula on a separate sheet that will compile all the data I marked with "X" so I don’t have to go back through each sheet to see all the related info. I have tried using various IF statements and so far have found nothing that will populate all the marked data to the final sheet.

For example in
Column A sheet 1 I have my data
Column B sheet 1 is where I will mark an "X" on relevant info
Column A sheet 2 is where I want all marked data to populate

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Please tell me it can be done. Thanks in advance<o></o>

 

[pboltonchina]

Try this on a copy of your data. Enter some 'X's and run the macro

Sub CopyX()
Application.ScreenUpdating = False
Dim LR As Long, i As Long
LR = Range("A" & Rows.Count).End(xlUp).Row
For i = LR To 1 Step -1
    If Range("B" & i).Value = "X" Then Rows(i).Copy Destination:=Sheets("Sheet2").Cells(Rows.Count, "A").End(xlUp)
Next i
Application.ScreenUpdating = True
End Sub