Can you keep grouped tabs grouped like it used to work?

As the title says; Can you keep grouped tabs grouped like how Excel used to work, instead of un-grouping every time you move around?

Background:
I have 3 co-workers and we are updating documents. A colleague created a shared spreadsheet with a master list of all of the documents and their status; one document (record) per row, and we all made corrections and status updates to it. But the workbook got corrupted and it is though that it may be because of the sharing?

My though was to create a shared workbook with a master tab and 4 working tabs (one for each of us), where the tabs could be grouped so that they would be kept identical, but the working tabs would be tables, sorted and filtered, to only show the documents each staff member is responsible for, so that they would only be editing their data, but the Boss would still have a master list.

Only I find that the grouping works differently now. Perhaps someone can suggest a different strategy if grouping is not viable?

I was hoping to find something fairly straight forward before looking into macros and VBA.

(I had 2010, but everyone has 2013 now).

Thanks
Chris

Thanks for the link. I hadn't seen the list of things you can't do in a shared workbook. I'm pretty sure someone cut some cells out.

Chris

Originally Posted by Richard Buttrey

Hi and welcome to the forum.

The usual way of doing what you want is to let individuals have their own individual workbooks and have a master workbook that contains macros that will gather the relevant information from the subsidiary workbooks.

unfortunately, all of the data in the subsidiary workbooks would be relevant and need to be gathered into the master workbook.

Ideally, the master would contain the entire list of documents and the subsidiaries would contain only those documents assigned to a staffer. Changes made to the subsidiaries would appear in the master and new documents (redords/Rows) entered or reassigned in the master would appear in the appropriate subsidiary.

I wonder if the new relational Data Model would be a start? I read that changes made in linked tables appear in the Data Model right away.

I'll have to think through a strategy first, but not knowing all of the available functions and resources makes it a bit complicated. I haven't programed excel in over a decade.

thanks!
Chris