Show row of data on seperate sheet if certain cell is checked on original sheet

Hi

I am trying to show data on a seperate sheet that has been checked on the original sheet. For example:

SHEET 1
Has rows or data showing name;time;age etc....Column A has a checked box that is blank but once any changes are made in a certain row that column A and row affected is checked so we can tell that there has been a change made on that row.

What i want is have these changes reflected on SHEET 2, to show the whole row for only the rows that have their column A checked.

How does this "check" work? I'm assuming col A takes a certain value (let's say "X") if the row is checked.

If so I would add an auxiliary column, with a formula that counts all "X" in col A from row 1 to that row.
Then that column would become the index for sheet2 (the first marked row will have a number 1 in the aux column, the second one a number 2...).

If this is not clear or you need any more help implementing the idea tell me!
Also, this is not very elegant... since you will have to predict the maximum number of columns with an X and if there are more they will not show in sheet2.

oh... one more thing. if your checking system for col A is working with an excel formula you won't be needing an auxiliary column... you can just add the functionality i mentioned to col A (and still show always an X in col A using number formatting)...

So far the data table in sheet 1 has 33 columns and 3184 rows of data. So once a change is made to any of the rows the user inputs any value into column A to the row in which the change is made.

eg. If row 10 in sheet one has the country changed from Aus to NZ, then the user will input 'any' value into column A, row 10 to indicate that that row has a change made.

Now on Sheet 2 i have the following formula placed on each cell to reflect any changes made in column A to reflect the value of that cell from sheet 1 to be shown in shet 2. I have followed this formula across onto the 33 columns and 3184 rows down. SO in turn the Sheet 2 reflects the same spreadhseet as sheet 1, however only showing the rows in which column A has a value. The formula is below:

=IF(Sheet1!$A2>0,Sheet1!B2,"")

This is then dragged along the cells to match its corresponding values, I then filter it and remove the blanks for it to then show only the rows that have been changed.

In simplcility.Is there a macro or code i can put in place to do this automatically to only show me the rows in which column A has a value from Sheet 1, on sheet 2?

as having formula on each cell makes the file really big.

Appreciate your help a lot!

Neil