Question

How do i automatically link data from one sheet to another in excel?

Answer 1

Answer:

Using functions and hyperlinks

Explanation:

If you need to edit and update the data you can use functions like Vlook up and find and ifs condition. but if you need to just read the data without editing you can use hyperlinks.