trying to reference cells from different files, need help quick

[ey3dol]

so i was wondering if there is a way to reference data from different excel files

example

I want to have a cell from file1 show on file2
and everytime that cell is updated on file1.. i want it to do the same on file2

idk if im explaining it clearly, i want it to like reference the cell from another file and update anytime that one does

is there a way to do this?

[NBVC]

Welcome to the forum,

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[JBeaucaire]

To reference a cell in one sheet from another sheet, you add the sheet ref to the cell ref. To get data from another workbook, you add that, too.

=A1
=Sheet1!A1
='[Book2.xls]'Sheet1!A1