Copying Attachments from One Sheet to Another

A basic rundown of what I am doing...

I have a list of meetings. One meeting per row. Multiple people will attach multiple documents to the appropriate meeting row. Each person could also have multiple topics for each meeting.

So for this month's meeting, Jane Doe needs to discuss topics, A, B, and C, and John Smith needs to discuss topics X, Y, and Z. Each will end up attaching a document for each topic.

There are approximately 25 people that could potentially be attaching documents for each meeting.

I have this sheet built and included in different things that I need to display on a dashboard through Metric Widgets and whatnot.

Each of these topics for each meeting will need sorted and put into a time slot.

I could do this on the same sheet as the meeting schedule that has the attachments, but then it quickly becomes rather unwieldy and messy. Executives need access to these attachments, but if I have my people going to one sheet to update a list then another for attachments, mass confusion will ensue, and if I put everything on one sheet so that EVERYONE is going there, it gets messy.

Sure... I could manually move things around, but the whole point of my boss asking me to move this process to SS is to make things more efficient than the current way of doing things (its very ugly/don't ask. haha).

.

I have every part of this process figured out and ready to go except for this one little hitch with the attachments.

Everything else I have been able to automate.

.

I guess I'll just have to suck it up and do some manual work until the Copy Row automation comes out. Haha

I can set up a reminder for the day before to go through and copy the attachments over. I was just hoping to be able to automate that part too.

What I am wanting to do is take the full, messy schedule where the attachments are added and topics are listed and move only the row for the next upcoming meeting to another sheet for cleanliness.

From there I would use formulas to sort each topic and assign time slots so that an itinerary can be generated with a much cleaner look than having it all done in one sheet. The attachments for that meeting would be in the parent row which holds the general meeting info such as a condensed list of topics, location, etc.

I can pull a report from the original sheet that shows only the row for the next upcoming meeting along with that same pertinent data and display that on the dashboard, but having a report in a Web Content widget for one single row just looks... odd...

Attached is a screenshot of the basics. The report has to be published because it isn't feasible to share everyone to the underlying sheet. The list of people changes rather frequently and just become too much to manage on top of my regular workload.

A published report can only be displayed on a dashboard using a Web Content widget. I am just not a fan of how it looks with the extra stuff across the top of the widget, and the paperclip isn't super obvious.

.

So technically a report could work, it is just very much so less than ideal.

Hahahahahaha. THAT would be great. I'll give you $12 per month. No benefits. No sick or vacation time. You buy your own pens, but I'll provide the post-its. Deal?