Macro to enter a find button

Question

1. I enter a number in the find and select box in excel. On pressing Find All the cell containing the number i want is selected.

2. A macro then selects the next worksheet and colour fills in a row of data and selects cell A1.

3. I press Find all and the number cell is highlighted on this worksheet.

4. A macro then selects the row containg the number and associated data and pastes it against the number in the first worksheet.

I want to automate stage 3 into stage 4 so when i run the second macro it actions the find all command.

Many Thanks in advance