Excel VBA - 2 x Export Range to CSV macro

Hi there

Please read whole problem before applying. I also need this done by the end of today please so don't apply if you can't do that.

I need someone to write me two excel VBA macros. One is to export the data from a range on an individual sheet to a csv file. The other macro is to combine ranges from multiple tabs and paste it to a csv file.

First macro
-Copy defined range (for example AD:BF or column 30-58 if that's easier) excluding any row where the first column (AD in this example) is blank (or "" with formulas).
-Paste values into new csv file
-sort by column A in new csv file (ascending)
-delete column A
-save as csv file in defined location with sheet name, date and timestamp as the file name.


2nd Macro (similar to above but combining multiple ranges into one csv file)
-copy defined range on multiple sheets (for example, AM:BO on the OCS tab, ) down to last active row, excluding rows where the first column is blank (or "" through formulas)
-paste to new csv
-repeat for other defined tabs (for example, then AD:BF on ALPG tab). There could be up to 100 different ranges so I just need the code to allow me to add more manually.
-then sort by column A
-delete column A
- also delete extra headings so that name, rd 1, rd 2 etc is only in row 1
- save as csv file in defined location with workbook name, date and timestamp as the file name

Have attached files as examples...
-SUMMARY.xlsm is the source (can't upload for some reason so can download from here (https://drive.google.com/file/d/1a1JTl9N_DtbqhpbljaF93kNO2hs91wms/)
-OCS_2020_06_22_12_29.csv is an example of an export I would like from the 1st macro
-SUMMARY_2020_06_22_12_29.csv is an example of an export I would like from the 2nd macro.

Any questions please ask. Thanks