I have 5 files and one master file.I want to automatically update those 5 files when I
Input on master file.

You need to give us more details. Do you mean files or tables? What database platform are you working in? Why do you have multiple copies of a master? Any other details you think pertinent may also help.

I have a excel file name "order in hand".I made many reports by using "pivot report" in
That file.On the other hand I need 5 more copies because other 5 person use that file with different Pivot Report.
Usually I made 5 copies of "order in hand" and then made different reports and send to different person.This is time consuming.Now I want My "order in hand" sheet linked with other 5 (folders,files, drive),so that when I input any data on; it change/ update data with other 5. I will make various report for their need first time, than I refreshing report ant send it to them
Hope I clear my question to u.

Yes that helps. I've moved your question to the Spreadsheets forum since it's a spreadheet issue, not a database issue.

But there is one more question here. Do the 5 users you share this spreadsheet with have access to a shared drive on your LAN? If not, there is nothing else you can do to automatically have their copies update.