Hi all,
Let me preface this by saying I am a novice when it comes to Access, I used it in college and that is about it. With that being said I am a little more versed in Excel and created the attached sheet to keep track of certain work things. My goal in Excel was to combine them all into a single Pivot Table which I did. The issue is everytime I add a sheet I need to redo the Pivot Table, which would be a hassle as I will continually be adding sheets. I'm hoping that there is an easier way this could be done using Access. The individual sheets are emailed to me and then I put them into one Excel file, is there a way to take that Excel file with all the sheets and import it to Access and be able to sort the data as I would with a Pivot Table in Excel? Any help (or if you just want to tell me no that is not what Access is for) would be greatly appreciated.