Creating a follow up list on first tab of large spreadsheet _HELP

[C.j.]

I have a spreadsheet with around 20 tabs of different clients to call from each state. Often times I have to leave a note to call them back the next day or week. I need to create something that list out all of the cleints that need to be called back form the entire spreadsheet into one tab. I can make a new column called "follow up" and if I insert a date into it excel would pull a copy of that particular row with client info and add it to a list on the first tab. I am not sure what the name of the function is called? pivot table? list? follow up list? any ideas?

[bigroo1958]

Hello! Attach a sample workbook. Make sure there is just enough data to demonstrate your needs. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[C.j.]

here is a list I made up. So certain ones have a date to follow up with, I need to have those rows listed out in a table or some type of list on the first tab so I can go through and see who to follow up with.

[bigroo1958]

CJ,

Here is a quick solution for one sheet!!
I believe this needs to be done in VBA to look at all sheets.

Thanks

[C.j.]

CJ,

Here is a quick solution for one sheet!!
I believe this needs to be done in VBA to look at all sheets.

Thanks

Is there not a table that pulls all rows that contain a certain value or date?

[FDibbins]

See if this will help. I added a helper column to each sheet (H) and used this, copied down...
=COUNTIF($F$2:F2,"<>")

On the 2nd sheet, in H1...
=MAX(Alaska!H:H)
then use the COUNTIF formula

Then, to pull the data you want...
A2=IF(ROWS($1:1)>Texas!$H$1,INDEX(Texas!B:B,MATCH(ROWS($1:1),Texas!$H:$H,0)),INDEX(Alaska!B:B,MATCH(ROWS($1:1),Alaska!$H:$H,0)))
copied down

[C.j.]

See if this will help. I added a helper column to each sheet (H) and used this, copied down...
=COUNTIF($F$2:F2,"<>")

On the 2nd sheet, in H1...
=MAX(Alaska!H:H)
then use the COUNTIF formula

Then, to pull the data you want...
A2=IF(ROWS($1:1)>Texas!$H$1,INDEX(Texas!B:B,MATCH(ROWS($1:1),Texas!$H:$H,0)),INDEX(Alaska!B:B,MATCH(ROWS($1:1),Alaska!$H:$H,0)))
copied down

I am not following you on where to put each formula? are you able to add it to the spreadsheet?

[bigroo1958]

CJ,

See if this will help. I added a helper column to each sheet (H) and used this, copied down...
=COUNTIF($F$2:F2,"<>")

This formula is added to each sheet under column H starting at row 2.

On the 2nd sheet, in H1...
=MAX(Alaska!H:H)
then use the COUNTIF formula

This is where I got lost as well.....

I am curious as well as to what FDibbins is alduring to as a solution.
I am always wanting to learn from these masters!!

Thanks