As we all know that Microsoft Excel is a very helpful and popular workbook data for the users to store any kind of important data. In Microsoft Excel users can perform several different types of tasks such as transfer data from one Excel worksheet to anot

Sometimes we want to use one sheet of the excel as a form that is used to get the inputs from the user. the data entered by the user, we try to save it on some other sheets that may not be accessible to the end user for the security of the data of course.

In Excel, copying data from one worksheet to another is an easy task, but there is not any link between the two. But we can create a link between two worksheets or workbooks to automatically update data in another sheet if it changes in the first workshee