I'm new to Excel... and I have to admint I'm stugglling!!

I have some csv files each row has the following fields

number text ... followed by 11 number data fields

There are a total of about 8000 rows per csv.

I have a number of pivotcharts that I want to create which I can do, but as soon as I try import new data I lose all my charts and need to create them again??

Basically I'm after a sheet that will allow me to select a cvs file and then poplate my charts.... is this possible???