I am looking for the simplest way to do the following:

Excel file one has 10 columns which has information added daily.
Excel File 2 needs to be a simplified report of file 1 - only containing 5 of those columns.

Either have file 2 be continually updated with the information entered in file 1 or have some kind of one click solution that when work is done on file 1 all new entries will be transferred to file 2.

Any ideas would be appreciated so much.