Master Sheet to get info from others sheet to follow updated task from a team

Alfredo Alva

In my company we have several worksheets where tasks are assigned to the finance team, how can I have the summary extract from all sheets with all the fields in a new sheet (all sheets have the same columns) where each time in a specific column ( responsible) is placed as the finance team make a link of all the values ​​of the row so we know all the pending to the team in a single sheet and from there the others are updated.

Paul Newcome

It sounds like you may be looking for a row report that looks at all of the sheets.

Andrée Starå

Hi @Alfredo Alva

I hope you're well and safe!

To add to Paul's excellent advice/answer, which I also recommend if it works.

Another option could be.

• You could use cross-sheet formulas combined with either a VLOOKUP or INDEX/MATCH structure to connect the sheets, and when you update the source sheet, it will reflect on the destination sheet.

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!