Transferring Data From Multiple sheets into one

English.xls

French.xls

Master Sheet.xls

Spanish.xlsHi,

I have information spread in multiple sheets. The information is the same except for 2 columns - One additional Name and the date of closure. I am attaching the excel sheets here. I have knowledge object names in english, spanish and french.

I want to transfer this information from multiple sheets into a single sheet which i am calling the master sheet. In the master sheet I want the information to automatically reach the moment someone types in the sheet of anyone of the language. For example, the moment i type bubba gump in english and put in the closure date it should appear in the master sheet and in the column in english there should be a tick mark or colour of some kind that says the work is done. Now if someone finishes the same in spanish it should appear in spanish column with the tick mark or colour of a different. The names of the knowledge objects should not be repeated. Or maybe the master sheet can just pick up the end date and display it there.

Please look at the sheets to have a clear picture of what I am trying here.

Your help will be greatly appreciated.

Regards

Mayank

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!