Entering data from one tab to multiple tabs

[MollieCNolan89]

Good Morning, 

I am trying to enter information into one tab, that will auto fill into another tab for multiple people and tabs. 

Example: if I enter a "X" into a column Example Photo E1, (L named 30)   I would like it to auto fill into the tab of their department (Photo E2) in the photo E3 column. 

is there a way to do this for multiple entries?  

[#2]

@MollieCNolan89 

With your permission, if I can recommend. It can help us all if you upload an Excel file (without sensitive data), no picture. Even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases. You could get a precise solution much faster with a file (w/out sensitive data). This would also be a blessing for all of us, as we can understand the problem much better, a win-win situation for everyone.

Thank you for your understanding and patience

Nikolino

I know I don't know anything (Socrates)

[#3]

@MollieCNolan89 

It all these are in one cell, you may select all sheets and enter the value. Otherwise XLOOKUP or like.