shahfahad,
It is always easier to help and test possible solutions if we could work with your actual file.
Perhaps you could upload a copy of your file to a free site such as
www.box.com or
www.dropbox.com.
Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here.
Include a detailed explanation of what you would like to do referring to specific cells and worksheets.
If the workbook contains confidential information, you could replace it with generic data.