Need advice on my site concept

I’m relatively new to WP and have created a simple site for a friend. I’m on my next project which is more complex. I would like to have a site that have users with different roles/access levels. Generally, there will be Admin user – create users, groups, assign user access levels to pages, etc. Data entry forms for users to enter data and saved directly into database table.

The site is supposed to capture data from users (public – assume this is group A) via a signup form (name, email, password) and after sign up, the user is sent a confirmation email of registration and provided a link or redirected to a page to capture information such as, [Name, Address, Phone#, Location, Amount, Date purchased, File upload, Email address]. Each user is allowed to enter more than 1 set of these information (or may be set to a max of 3). This will be the front end form.

There will be an admin level user (assume this user is Group B) that can also enter the same data via a backend form and the data will be saved into the same database table as normal users (public).

There will be special group users that will be setup. These users will have multiple groups (e.g. Group C, Group D, Group E, etc). Each group will have access to specific pages only. These pages are basically sql select filtered data selected from the database table. E.g. Page1 will have data selection of Amount 0 – 500, Page 2 Amount 501 – 1000, etc. Further example, Group C will have access to all pages, Group D can only access Amount 0-500 page and so on.

I need advice from you guys that have used WP. Is this do-able in WP and if there are any specific plugins that you could recommend for such a site concept.

Appreciate your feedback.