I am a beginner in VBA coding for excel.
every year I organized four excel files for students. I need to collect the data of a specific sheet in these four excel files and send its data to another excel file (file GPA) for further process of calculating the average graduation mark for students. can you please help me to prepare this code? I have attached these files as examples. I need to collect the data for these four files every year into one file (file GPA).
many thanks for your help
