Updating Separate spreadsheets by entering data in a single sheet.

[ismail123]

I have a master sheet with employees' Details.
Maintaining sheet1 for Passport datas, sheet 2 for visa datas, and sheet three for qualification and misc.datas.
What I like is instead of going every sheet to update the records or correction, i would prefer to enter data in a single sheet based on a reference no (given to each employee) and update the other sheets automatically.
Hope i explained my question.

 

[MiniGangsterPug]

So you are going to type everything into the mastersheet and the other sheets will take the info from that mastersheet and put it into the other sheets? Is that what you want?

 

[ismail123]

So you are going to type everything into the mastersheet and the other sheets will take the info from that mastersheet and put it into the other sheets? Is that what you want?

No, I will have a sheet like A1 ref.no
A2 license expiry
A3 vehicle registratio
A4 license issue date
A5 license expiry

Now first I will type the ref.no (each sheet has the reference no)
Then fill the required rows as per the update or correction.
After entering, the data has to be updated in the sheets dedicated seperately for seperate details

 

[ismail123]

No, Actually I need a sheet just like a tabular form. Where i enter the data and multiple sheets are updated as per the data entered in Tabular sheet. (Like Access Point works)

 

[ismail123]

Actually I need a sheet just like a tabular form. Where i enter the data and multiple sheets are updated as per the data entered in Tabular sheet. (Like Access Point works)