How to link two or more worksheets for creation of a completely new worksheet?

[arbind gaba]

I am a regular user of Microsoft excel for over a couple of years, but I still face issues while performing some functions, which seems way too difficult. For instance, there are times when I need to link two worksheets from one of my previous excel files. This will allow me to pull useful information from the newly created worksheet, however, I am not able to perform the task as I don’t know how I can achieve it. If there is anyone here who can help solve this issue of mine, I will be extremely grateful as this will help save a lot of time and effort for me.

 

[Shteven]

Sorry arbind, I'm not sure I understand your question. Are you able to attach a file with your issue and the expected results?

It is easy to use data from another worksheet. Type = and then click another worksheet tab, and finally the cell/range you wish to reference.