Tracking rows from other sheets
I have several rows from different sheets that feed my master sheet via "move row" automation. I need to track in a column on my master sheet which row is coming from which sheet.
The only approach I can think of is adding a column on each sheet with its name so when the row is moved, it is added to the master sheet.
I am not a big fan of this solution as it forces me to add yet another column. Is there a more "elegant" way to resolve my issue (ideally I would like my master sheet to detect from which sheet the row comes from and display its name)
Thanks in advance.
Help Article Resources
Check out the Formula Handbook template!