The excel spreadsheet of what I need the data to look like is enclosed as a sample. Sheet 1 has had the links.
First excel is to open the webpage by following the first link, enter a date in to a date selection window that's two weeks ahead of the current date, enter the courthouse name Stanley Mosk, enter the case type Civil Unlimited and download the calendar for that Deprtment.
Then, repeat this step for all departments (50- 80 times or so)
Next, go to second webpage link and enter the first case number from the first downloaded [login to view URL] submit button. From the webpage that opens get the first and last name of the Attorney for Plaintiff, Attorney for Petitioner , attorney for defendant attorney for respondents or LARRY in pro per. Repeat this for each case number (500-800 times) and get the data.
Then, go to the third link, enter the name of the first attorney in the search box, and get their phone number and email address. If more than one similar name then get each [login to view URL] this step until email and phone numbers for all attorneys whose names names we got in step 2 are ran:
Organize the data in the spreadsheet as shown in the attached sample.
Save the spreadsheet in a folder automatically and name it by step 1 query date.'