从一个csv工作表移动到python脚本中的下一个工作表

I've been using excel to create .csv workesheets that I'd like to parse using python. Each worksheet is named after a shop (e.g worksheet 1: "Waitrose", worksheet 2: "Tesco", worksheet 3: "Asda") and contains a list of products (column 1) and their associated prices (column 2). I've written a python script that can access a worksheet and turn the contents into a dictionary (see below) but am struggling to find a way to get the program to access the next worksheet in the workbook. I want to end up with as many dictionaries as worksheets. The csv module doesn't seem to be of much help and I can't find a current third party python 3-compatible module that deals with excel. I was thinking maybe applescript but am not sure how I'd embed this in a python scriptI've been using excel to create .csv workesheet