Extracting Unique Values from Other Sheet

[loknath]

<table style="width: 521px; height: 137px;" border="0" cellpadding="0" cellspacing="0"><col width="64"><tr height="19"> <td style="height:14.4pt;width:48pt" height="19" width="64">Dear All,
I have 3 sheets where the Students Percentages are calculated.
I want to extract the Student Name and Percentage (from Sheet1,Sheet2,Sheet3) as per their Position(based on top percentage) in the class (only upto Rank-4) to a sheet called Analysis in the following format.
<table style="width: 329px; height: 149px;" border="0" cellpadding="0" cellspacing="0"><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:2730;width:58pt" width="77"> <col style="mso-width-source:userset;mso-width-alt:2929;width:62pt" width="82"> <tbody><tr style="height:14.4pt" height="19"> <td colspan="3" style="height:14.4pt;mso-ignore:colspan; width:168pt" height="19" width="223">Class Toppers for Section-A</td> </tr> <tr style="height:14.4pt" height="19"> <td class="xl65" style="height:14.4pt" height="19">Position</td> <td class="xl65">Std Name</td> <td class="xl65">Percentage</td> </tr> <tr style="height:14.4pt" height="19"> <td style="height:14.4pt" height="19">1st</td> <td>
</td> <td>
</td> </tr> <tr style="height:14.4pt" height="19"> <td style="height:14.4pt" height="19">2nd</td> <td>
</td> <td>
</td> </tr> <tr style="height:14.4pt" height="19"> <td style="height:14.4pt" height="19">3rd</td> <td>
</td> <td>
</td> </tr> <tr style="height:14.4pt" height="19"> <td style="height:14.4pt" height="19">4th</td> <td>
</td> <td>
</td> </tr> </tbody></table>
Hope you all will help me out with a formula.
Thank you.

loknath
</td> </tr></table>

 

[anandvarma]

Watch the EXCELMAGICTRICK#185,186 at excelisfun youtube channel by Mr. Mike Girvin