Problem having data auto update from one worksheet to another

I am trying to pull data from one worksheet (Database) to another (Data Final) using IF functions.

Eg. To populate the Data Final worksheet with the names of only people who are active in the club I'm entering something like this:

=IF('Database'!CG1=1, 'Database'!A1, "")
=IF('Database'!CG2=1, 'Database'!A2, "")
=IF('Database'!CG3=1, 'Database'!A3, "")
=IF('Database'!CG4=1, 'Database'!A4, "")
=IF('Database'!CG5=1, 'Database'!A5, "")

It's working well, but, when I add someone to the Database worksheet, it does not populate in the Data Final worksheet, instead, the formula in the Data Final worksheet skips a number. So, for example, if I added a row at row 3 in the Database it would give this in my Data Final worksheet:

=IF('Database'!CG1=1, 'Database'!A1, "")
=IF('Database'!CG2=1, 'Database'!A2, "")
=IF('Database'!CG4=1, 'Database'!A4, "")
=IF('Database'!CG5=1, 'Database'!A5, "")
=IF('Database'!CG6=1, 'Database'!A6, "")

Anyway that I can change my formula so that it updates in Final Data when a row is added to Database?

Any help would be greatly appreciated!