Best Of

@Devi An Devi: Here's the best way to manage this. You will need four separate documents:

Documents

1. A sheet to capture all of your PM tweets. You will need to have three columns: "PM Name," "Update Date," and "Update Tweet" (or something along those lines)
   1. PM NAME: Make this Column2 and change it to a dropdown menu. Add all of your PM names here.
   2. UPDATE DATE: Make this Column3 and change it to a "Date Type" column and make it "date only."
   3. UPDATE TWEET: make this your Primary Column, since this only needs to be a text field.
2. Using the sheet to collect the data above, make a form that directs back to this sheet. You can provide the same form to all of your PMs and this will function as a repository for all of the data you wish to push out to your dashboard.
3. You will need a data sheet designated to act as a place to collect the most recent data to push to your dashboard AND as a helper column location to navigate your desire to have this data change live. I will include the formulas below.
4. Your dashboard. This will direct back to your data sheet in step 3.

For the Data Sheet your first step will be to create Helper Columns to allow you to navigate identifying the most recent data a PM has put an entry. To do this you will need Three Separate Columns:

NAME OF PM - In this column list every PM that you need to collect an update tweet for. Please list one PM per row. It should look something like this:

Last PM Entry Date - The second column needs to be a date column, but do not select "Date Only" as you are going to need to enter in a formula to collect this date. The formula is as follows:

=MAX(COLLECT({Update Date Column From Your PM Data Sheet in Point 1 Above}, {PM NAME Column From your PM Data Sheet in Point 1 Above}, [NAME OF PM]@row))

What This formula will do is reference the entire Date Column on Your Sheet that collects the submissions rom your form and pull back the MAX, or most recent date for the name of the PM you assign to this search. Make sure for the two parts of the formula above that reference the other data sheet (Point 1 above), that you select the entire row as the reference, so as new data populates it catches it).

PM UPDATE TWEET - The Third column on this data sheet will be the equation that takes your date you've identified as the PM's most recent tweet date and then goes and finds the Tweet that matches both the PM name and the Date you've identified. That formula looks like:

=INDEX(COLLECT({Reference the entire UPDATE Tweet Column from your data sheet from point1}, {Reference the PM NAME Column from your data sheet in Point 1}, [NAME OF PM]@row, {Reference the entire Date Column from your data sheet in Point 1}, [Last PM Entry Date]@row),1)

So your data might come back looking like this:

Then you simply build your dashboard and have your Text Widgets Just be a fixed name for your PM and then the actively changing widget point back to the tweet. You could also add a widget that points back to capture the most recent date.

I hope this helps!