How to merge excel worksheets into one master worksheet

Previously i was working for some of my projects and got a problem to solve. Here i have providing a Visual  Basic script which will help y...