Hello,

I have 365 excel files with the first page containing 2 columns. An account
number and the cash in the account.
Everyday a new account could be added or removed from the sheet.

What is the best way to pull all these files into one graph?

How could I further filter the accounts by saying only account Numbers
ending in a B or an A.

How can I show on the line chart when an account drops off the chart.