how to have a server feed excel with the updated data without opening source

[rouzacct]

I have already posted a similar question yet no answers...

So i will re-word my question

I get 12+ sheets (CSV that i save as Xlsx) on a daily basis and store the old ones away so they are always in the same Dir*/.
I need them to be able to self feed to Excel so that I dont need to have them open to use my linked formulas in my workbook.

I have looked into connections and i dont get the big picture
what is it that im not getting ....
i googled and some talk about a SQL server .
Some talk about Sharepoint..

I have office 2010
I created a Groove workspace
I added a few of the sheets to my documents so they apear on the right in
sharepoint workspace
but i still dont get how i must get excel to pick up data from there

Im sure this is a multi step thing that depends on many things settings

what i am looking for is a bit of guidence ..
tell me what else I should google
what should i do before i do anything ...

just any help helps ..

Thanks

 

[mole999]

there are quite a few posts on here about, importing data from closed work books on a path, scripted from within one active workbook