Automatically update the data in Master file

In my team have a 5 sub team every team using a separate file for own process where updating the productivity and quality on daily basis.

I want to create one master file where automatically update the productivity & quality on same time.

I have attached 3 file for reference.

1. Master file
2. Product Info
3. Usage

what i am trying when product info team update our productivity & quality in Product Info file then automatically update the same in Master file on PI portion.
and when usage team update our productivity & quality in Usage file then automatically update the same in Master file on Usage portion. etc..

Please help me out I am not good in VBA.

Thansk & Regards
Abdul

anybody can help me out.

Thanks
Abdul

Hi, if the cells are comon in Master and other two files , you can use formulas to update the values in master file.

Yes cells are comon, can you tell me which formula i can use.

i tried paste as link but the problem is that its showing 0 in blank cells.

Thanks,
Abdul

hi, you can make use of "IF" fucntion in master file...

for example: for cell F% in Master file...
=IF('[Product Info.xlsx]Daily-India'!$F$5="","",'[Product Info.xlsx]Daily-India'!$F$5)
if the cell is empty in PI file, the cell in Master file will be empty. if cell contains any value, same will be displayed in master file...
Regards, sathyaganapathi,

Hi,
formula is working but i am facing the same problem its showing 0 in empty cell

Thanks
Abdul

Hi, can you please upload the excel file with your formula in?? and mark the cells....
thanks.

Hi,
Now the formula is working fine. but file is updating only when both are opened.
Can it is possible when i open the master file then data is to updated. no matter Product info is open or close.

please help me out.

Thanks
Abdul

If the files are in the same dive, data will be updated. you can use "Data refresh" options to refresh the data when file is opene.
Hope ,this helps you...
regards, sathyaganapathi.