Naming Ranges in Excel

Ok, I have a spreadsheet with 12 worksheet, each with 5 columns. In order for Quantrix to see the columns, I understand that I need to name each range. But that is a lot of typing (60 columns).

Is there a way to have Quantrix just read the name of the columns in the Excel spreadsheet? Or is there another way to automate this?

My tired fingers will thank you for any suggestions!