List Look Up From Another File?

Hi Excel Users,

I created a file or a template that tracks my charge numbers for multiple jobs. In another file, I have a Timesheet spreadsheet.

I would like to create a "LIST" that references my Charg Number spreadsheet, without having to create a bunch of cells equal to each other from 2 different files.

Is there a way to one file refer to another file, just by having the 2 files open & havea nice "LIST" drop down menu?

Thanks