I AM WORKING WITH AN EXCEL FILE THAT CONSISTS OF SEVERAL CLIENTS' DATA. SINCE IT IS QUITE DIFFICULT TO MANAGE AN INDEFINITE NUMBER OF DATA, ESPECIALLY COLUMNS, I WOULD LIKE TO USE THIS FILE AS MY MASTER FILE OR TABLE.
I WANT TO CREATE SEVERAL OTHER FILES THAT WILL BE DIRECTLY DEPENDENT ON MY MASTER FILE

e.g. MY MASTER FILE CONTAINS THE FOLLOWING COLUMNS: A=client code, B=tomn, C=region, D=client name
I WANT TO CREATE ANOTHER FILE(S) WHERE THE FIRST FOUR COLUMNS WILL BE AUTOMATICALLY FILLED IN AND UPDATED, DEPENDING ON MY MASTER FILE.

IS THAT POSSIBLE WITH EXCEL? IF YES HOW

I HAVE TRIED TO DO THAT THROUGH ACCESS BY LINKING MY MASTER EXCEL FILE AS AN ACCESS TABLE. I CANNOT CHANGE, HOWEVER, THE PROPERTIES OF THE LINKED TABLE INCLUDING ADDING OR SUBTRACTING COLUMNS

COULD ACCESS BE MORE APPROPRIATE FOR COMPLETING THIS TASK? IF YES HOW

YOUR HELP WOULD SAVE A LOT OF TIME!!! PLS HELP ME!!