Hello,

Please forgive me of any misuse of excel terms, I am self-taught and trying to put together a complicated spreadsheet for my business.

My goal is to have a spreadsheet with mulitple sheets for a publishing business.
1) Clients List - All clients data, including their rate and dates which they run (bill)
2) That month's accounting sheet - This sheet will pull over any client that is running in the current month (seleceted by a drop down at the top with pre-determined dates)

I found this formula online, and it seems to work, but it is just pulling one piece of data, not any more.
I also can't seem to figure out why it it choosing just this one particular client/piece of data.

=IFERROR(INDEX(MyClients[I Sold into my Neighborhood],SMALL(IF(MyClients[First Issue Date MM/YYYY]>=$B$1,ROW(MyClients[I Sold into my Neighborhood])-ROW(MyClients[I Sold into my Neighborhood])+1),ROWS($A$15:A15))),"")

I have included the sample spreadsheet.
MagicNumberHelp.xlsx

Help! Is there a way to get this to work?

Thank you to any genius that can figure this out!
Lisa