Hi All,

requesting help for the below,

i have workbook in which one of the sheet name is "Summary".

Now everyday i receive another workbook. I want vba code to move copy of this sheet "Summary" from one workbook to another.

i want something like...........If i click any shortcut key to triger macro on the Active workbook. It should get the summary sheet from the specific workbook and should get copy of that sheet in this active workbook.

please help me guys.....