How to extract the XPath from an XML in sql server?

I have trying to update/create a table from the XML string using the below stored procedure.

CREATE PROCEDURE [dbo].[usp_Import_Material_Charge]  
(@passedXMLStringForSQL xml)  
AS  
BEGIN

SET NOCOUNT ON

            
            DECLARE @xmlHandle INT;

            EXEC sp_xml_preparedocument @xmlHandle output, @passedXMLStringForSQL

            SELECT * into ClothingMaterialRecon..Material_Charge
            FROM OPENXML (@xmlHandle, '/NewDataSet/Sheet2', 3)
            WITH ([Material]            varchar(50)       'Material',  
                  [Description]         varchar(50)       'Description',  
                  [MRP]             decimal(7, 2)     'MRP',  
                  [Material_Charge]     decimal(7, 2)     'New_Material_Charge')
            
            EXEC sp_xml_removedocument @xmlHandle

END

I have been successful in creating the table so far. But I was thinking of trying something new.

I was trying to replace '/NewDataSet/Sheet2' rowpattern(XPath) with a scalar variable.

The variable will contain the XPath. I wanted to extract the XPath by querying in the XML itself, but no luck so far.

Is there a way to get the XPath by querying the XML string so that we could use it for any kind of XML? XML can be different types and not every XML will have a same pattern of XPath as shown above.

Is there a way to make this dynamic/non-dependent on manually searching the XML for XPath?