Well, one way would be to use the Data-Import External Data-New Database
Query and select CSV files as the source database.

Drawback: it's completey manual & you'll have to go through it 41 times

Another way is to choose File-Open, select all 41 CSV files, and let Excel
open them. Each will open in its own workbook. You can then copy and paste
from each CSV workbook to the appropriate place in your existing sheets.

Drawback: it's still lots of manual work, but should go quicker than the
first option.

Third way - write VBA code to open each CSV file in turn and copy the data
into the correct existing sheet.

"Mintz87" wrote:

i have 41 csv files that i need to import into 41 sheets in Excel. the name
of the csv files and the sheet names are the same minus the extension (.csv).
The sheets will be existing sheets with headers. Please Help the Novice

thanks

M3ntz