Dear Experts

For index match, I am using following function, this works fine
PHP Code:
=INDEX(Party!$B$2:$B$250,MATCH(Rpt_Daily!C6,Party!$A$2:$A$250,0)) 
source sheet=Party
Target Sheet=rpt_daily

Question-1

How to use above formula with command button.

I mean while pressing commandbutton, sheets("rpt_daily") must updated with sheets("Party")

Question-2

How to use above fourmat with offset() funciton?

Please help