Several Spreadsheet Merger

[Brian_D]

Hello everyone,

I am currently working on updating a series of permits/business information. I have a total of 44 different locations so currently I have 44 different worksheets in one document.

I was wondering if there is any way to link information from this one to another based by month and required updates?

So example

location 43 has two permits due on july 13th
location 3 has five due on july 13th also.

I would like to create a spreadsheet that would take all of the locations July information and link it there with what is needing to be done.

Is this possible?

[FDibbins]

Hi and wwelcome to the forum

Without actually seeing what your data looks like, its hard to say

i would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[Brian_D]

Added in. I have to many so I just threw some together. But basically what I want to take information say from sheet 1-3 and if there was any June required updates it automatically to be moved over to another document that I have created for January-December for deadlines. I have all these already built in on my main location spreadsheet, but I want to make a main spreadsheet just for what is due in 2013, 2014 etc.

[FDibbins]

If your data will be in the same place on each sheet, you could maybe make a summary table with dates from all sheets, andthen use CF to highlight like you have on wach sheet.

I entered "sheet1" in K2.
you could either make this a drop-down to go through each sheet 1 at a time, or just copy the sheet name down to create a summry table
Then in L2, copied down...
=IF(INDIRECT($K$2&"!B"&ROW(A18))<1,"",INDIRECT($K$2&"!B"&ROW(A18)))