PLS HELP How can I fill the columns automatically from another excel sheet

How do I make it when the "Deposit paid" in drop-down box option under column G is selected that, that rows data is copied automatically onto the next sheet.