Hi!
I am working so hard to create a spreadsheet of information for my organization that has complete information on grants that we have received or are anticipating receiving. One work sheet needs to be organized by Program and Foundation name - with columns that identify potential reporting deadlines. Not all foundations have the same number or type of deadline, so many of the cells in each row are blank.
I want to be able to link this to a simple spreadsheet organized by date of deadline. The master spreadsheet will constantly be changing - as grants change etc.
Can i create a system of links that draws data (date, program, foundation) - only when there is data - and adds it to the deadline spreadsheet?

I will attach a small sample of what I am talking about.

I know how to set up links between tabs for existing data - but what I am picturing is being able to tell it - "when E5 has data I want it linked to the last row of tab 2 - along with E1, and A2"

Possible?

Also I'm open to changing the format of these two spreadsheets. I'm new to this!

Thank you!!sample linked worksheet.xlsx